PHP while/or?

[TheServant]

I have a loop picking up some data from a MySQL query but if it doesn't find anything I want it to print out something else. Obviously if I use mysql_fetch_array() to test it, my while loop will not pick up the first value so here is what I have:

    $raw_msgs = mysql_query("SELECT...") or die(mysql_error());
    if (empty($raw_msgs)) { echo("No messages."); }
 
    while ( $msgs = mysql_fetch_array($raw_msgs) ) {
        echo("...");
    }
 

I have tried putting the if statement in the while loop, but very quickly realised how dumb that was because the while loop was not running if it is empty. So is there a while/or function or something which can check if a query is empty without affecting fetching?

[Dormilich]

if (MySQLi_Result->num_rows === 0) {...}
// or
if (mysql_num_rows($raw_msgs) === 0) {...}

you should read this one: PHP: MySQL Functions

[TheServant]

Thanks heaps. I have read it before but what is the difference between == and ===?

[Dormilich]

the latter checks the type too.

[TheServant]

Ahh yes. Thank you for your help.