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 = 
                                                  and author.author_code = 
                        $result_cat = mysql_query($query_cat) or die
                        $num_results_cat = mysql_num_rows($result_cat) or die
                        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

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

Reply via email to