RE: [PHP-DB] Can't see the results

[Wilmar Perez]

Hi guys, it's me again.

Well, I did as Peter suggested and changed my code for this:

$query_cat = "select author.author_names || ' ' || author.author_surnames 
                                                  as author_full_name from 
author, authorxcat
                                                  where authorxcat.cat_code = 
$code
                                                  and author.author_code = 
authorxcat.author_code";
                                                
                                        
                        $result_cat = mysql_query($query_cat) or die
($mysql_error());
                                
                        $num_results_cat = mysql_num_rows($result_cat) or die
($mysql_error());
                        
                        while($row = mysql_fetch_array($result_cat))
                        {
                                $content .= $row["author_full_name"]."<br>";
                        }


Well, it should give me the full name of 22 people but all I'm getting is a 
row of 22 zeros.  I checked the database and in fact the data is there.

Any idea of what I could be missing?

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