You're absolutely right.
It must be the 1.5 hours of sleep last night that made my brain shrivel
up like that. 8(


On Thu, 9 Jan 2003 17:45:00 -0500, John W. Holmes wrote:

>> ...
>> if ($result) {
>>      while ($row...
>>      ...
>> }
>> $result will be 0 (false) if nothing satisfies the query.  Any other
>> comparison is just extra typing with no improvement in logic.
>No, it only returns false/0 if the query fails, meaning there was an
>error and the query couldn't be executed. The query can execute just
>fine, return no rows, and so the result would be true. 
>What you have is extra typing with no improvement in logic. ;)
>If you need to know the number of rows returned, then use the
>if(mysql_num_rows() method. If you don't, then you can do this:
>if($row = mysql_fetch_row($result))
>       do{
>               //do whatever with $row data
>       }while($row = mysql_fetch_row($result));
>{ echo "no rows returned from query"; }
>If you simply do not want something done if no rows are returned, then
>the simple while($row = mysql_fetch_row($result)) method works fine, as
>the while() will only be true if rows were returned and skipped if no
>rows are returned.
>---John W. Holmes...
>PHP Architect - A monthly magazine for PHP Professionals. Get your copy

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to