Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002091

[PHP-DB] Can't see the results From: Wilmar Perez (wilmar.perez <email protected>)
Date: 09/06/02

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
*******************************************************
 
          

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php