[RESOLVED] 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 make it output if its not found:

echo 'Sorry I could not find it';

Thank you!

[Piranha]

$sql = 'SELECT * FROM staffing WHERE date = "'.$variable.'"': // First setting a variable to have an easier time to debug.
$result = mysql_query($sql);
$no_rows = mysql_num_rows($result);
if (0 == $no_rows)
{
    echo "Sorry, nothing returned";
}
else
{
    while ($row = mysql_fetch_array($result)) 
    {
        echo 'Yay I found it!';
    }
}

[MattG]

Another possible way is...

$result = mysql_query("SELECT * FROM staffing WHERE date = '$variable'");

if ($myrow = mysql_fetch_array($result))
{
    do {
        echo 'Yay I found it!';
    } while ($myrow = mysql_fetch_array($result));
}
else
{
    echo 'Sorry I could not find it';
}

[christo16]

Thank you so much everybody! That works perfectly!