If not found in the database?

[Michdd]

What would the statement look for when I'm using

 

$result = mysql_query("SELECT * FROM pets WHERE id='$id' ") 
or die(mysql_error());  

 

And if id='$id' doesn't exist in the database, how would I make it return, "There is no such row"?

[rhodesa]

$result = mysql_query("SELECT * FROM pets WHERE id='$id' ")
  or die(mysql_error());
if(!mysql_num_rows($result)){
  echo "There is no such row";
}else{
  $row = mysql_fetch_array($result);

}