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