[PHP] dealing with no record

[[EMAIL PROTECTED]]

People
If I run a sniplet like this:

**********************
$query="select name from foo";
$result= mysql_query($query);
while($row = mysql_fetch_row($result))
 stuffssss.......to display record found....
...
***********************
what am I suppose to do if I also want the code to be able to deal with the case that 
no record found  and redirect user to other page?
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for yourself"