RE: [PHP-DB] Can't see the results
| From: | Wilmar Perez | Date: | Mon, 09 Sep 2002 12:23:22 +0000 |
| Subject: | RE: [PHP-DB] Can't see the results | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21641@lists.php.net to get a copy of this message | ||
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
*******************************************************