Can't see the results
| From: | Wilmar Perez | Date: | Fri, 06 Sep 2002 21:43:56 +0000 |
| Subject: | Can't see the results | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21619@lists.php.net to get a copy of this message | ||
Hello guys
Thanks to all those you helped me with y the question I made before (not a
valid MySQL result) it's working now.
Now, I want to display the result of my search with the following code:
if($code){
$query_cat = "select author.author_names || ' '|| author.author_surnames
as full_name from author, authorxcat
where authorxcat.cat_code = $code
and author.author_code = authorxcat.author_code"
or die($mysql_error());
$result_cat = mysql_query($query_cat);
$num_results_cat = mysql_num_rows($result_cat);
for ($i=0; $i < $num_results_cat; $i++)
{
$row = mysql_fetch_array($result);
$content .= $row;
/*
$content .= htmlspecialchars(stripslashes($row["author_names"]))
." ".htmlspecialchars(stripslashes($row
["author_surnames"]))."<br>";*/
}
}
But I just get the following:
ArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArray
I also tried to do it commenting the "$content .= $row;" and uncommenting
the lines that are commented in the code but I just get a blank page.
What am I doing wrong?
Thanks a lot for your help.
*******************************************************
Wilmar Pérez
Network Administrator
Library System
Tel: ++57(4)2105145
University of Antioquia
Medellín - Colombia
2002
*******************************************************