If.... else for a MySQL query?

[christo16]

Ok this may be an easy one, if my query doesn't find anything how do I make it output some text. Example, so if my query below doesn't find what its looking for

$result = mysql_query('SELECT * FROM staffing WHERE date = "'.$variable.'"');
   		while ($row = mysql_fetch_array($result)) { 
                      echo 'Yay I found it!';                        }

and if it doesn't find anything output some text:

 echo 'Sorry I could not find it';

Thank you!

 

[worldworld]

I think you have to use mysql_nums_rows() to find that query has any row found for you or not. 

[fenway]

Actually, if all you want to see is if any records match, but don't actually want the records, a COUNT() will suffice.