How can I get php to return true or false when it checks a database for a var?

[pneudralics]

I want to look for id 9. I know how to check the database with WHERE = '9', but what do I do to make it return true or false when it finds or not find 9?

 

I pretty much want to check the database field id for a specific number. Not sure if the above is the way to go. I want php to tell me they found 9 or not.

[trq]

if ($result = mysql_query("SELECT id FROM tbl WHERE id = 9")) {
  if (mysql_num_rows($result)) {
    // found
  } else {
    // not found
  }
}

[pneudralics]

Thanks again.