Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002091

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

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