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