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