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
