Re: simple question -Select statement and recordset
| From: | Matt King | Date: | Wed, 14 May 2003 15:32:52 +0000 |
| Subject: | Re: simple question -Select statement and recordset | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27748@lists.php.net to get a copy of this message | ||
Angelo Zanetti wrote:
> it works fine because I display the no rows effected and it echo's 1.
The most common method:
$result = mysql_query("select title, abstract, keywords from Biblio where
BiblioID = " . $ID);
if (mysql_num_rows($result))
{
while ($row = mysql_fetch_array($result))
{
// echo anything else in here, it will display all results
echo ($row["title"] . "<br/>");
}
}
else
{
echo ("No Results Found!");
}
--
Matt King
magnet | internet
http://www.magnetinternet.com