Re: Strange bahavior with mysql_fetch_array($result)

Shahmat Dahlan <shahmatd@xxxxxxxxxxxx> · Fri, 21 Nov 2003 10:27:48 +0800

What of the sql statement? If your sql statement had mistakes in it (be 
it typo, or wrongly constructed statements), it will not even execute 
the if (!mysql_fetch_array($result)) { .... } portion of your code. You 
might want to construct your error checking portion differently as 
opposed to what you have now.

Gerald Samuel's and Kirk Babb's code should fit your requirements.

Gerard Samuel wrote:

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';
}