Re: Strange bahavior with mysql_fetch_array($result)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux