check if id exists...

[mkosmosports]

I want php to run and make a quick check to see if an id exists in mysql. This id features as a url parameter.
Currently I do by running a query and selecting all of the id's, putting them into an array and running a condition that if the id in the url isnt in that array show an error page.

Is there a quicker way of doing this, perhaps without a mysql_query, but using some other mysql function?

Thanks!

[DarkendSoul]

[code]<?php
$checkID=mysql_query("SELECT * FROM table WHERE id = '{$_GET['searchID']}'");

if (mysql_num_rows($checkID)) {
// Id exists
}
else {
// Id doesnt exist
}
?>[/code]

[trq]

You still need a query but grabbing all rows is rediculous.

If the id is contained within the url, use it in your query.

[code]
<?php
  $sql = "SELECT id FROM tbl WHERE id = '{$_GET['id']}';";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      // id exists.
    }
  }
?>
[/code]

[mkosmosports]

Thanks fellas! That makes sense. I gotta start figuring those out...