No results found - simple help

[Mr Chris]

Hi,

 

In the below query:

 

<? 
  $SQL = "SELECT * from xxxx";
  $result = mysql_query($SQL) OR die(mysql_error()); 
    while ($row = mysql_fetch_assoc($result)){ 
      echo 'Blah, Blah Blah';
    }
     if (!$result){ 
       echo 'No results';
    } 
?>

 

If I find no results I want the no results message outputted.  But It does not work.  Can anyone explain why?

 

Thanks

[graham23s]

have you tried:

 

     if (($result) == 0) { 
       echo 'No results';
    } 

 

Graham

[Mr Chris]

Yep,

 

Still the same thing though, just absolutely nothing outputted?  Just blank space...

 

Any other suggestions

[noidtluom]

Use mysql_num_rows to check how many rows you get. Then if (mysql_num_rows($SQL) == 0) { echo 'No results'; }