On Thursday 20 November 2003 08:54 pm, Evan Panagiotopoulos wrote:
> I am searching a table and have the following php code with my
> comments:
>
> $result = mysql_query($query);
> print "The result == $result";
> // it returns The result == Resource id #2"
> if (!mysql_fetch_array($result)) {
> ...
> } else {
> while ($row = mysql_fetch_array($result)) {
> ...
> }
> }
Try ->
$result = mysql_query($query);
// Test to see if the query failed
if ($result === false)
{
die('some meaningful message');
}
// Test to see if there are results to return
if (mysql_num_rows($result) > 0)
{
// Get results
while($row = mysql_fetch_array($result))
{
....
}
}
else
{
echo 'No Results';
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
