Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002091

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

Hello guys (again)

Well, just wanted to let you know that my code is working now, at the end it
worked thanks to the help of Jim and Peter. The following is the resulting
code just in case anyone can make use of it.

Thankyou so much.

$query_cat = "select concat(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>";
                        }

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