Hi guys, it's me again.
Advertising
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
