php mysql

what would be the code to check if an ID does NOT exists? i can do a long code, but i was wonderting is there is some kind of those funcstions that no one knows about from mysql

thanks a lot

Do a query to see if it exists or not.

$query = mysql_query("SELECT id WHERE id='$idnumber'");
if(mysql_num_rows($query) > 0)){
echo 'ID exists';
}else{
echo 'ID doesnt exist';
}


Or I guess I could've done

$query = mysql_query("SELECT id WHERE id='$idnumber'");
if($query){
echo 'ID exists';
}else{
echo 'ID doesnt exist';
}

actually your second one wont work, as mysql_query returns true if the query is executed successfully, whether is returns any rows or not.

lol I dunno why I came back 2 hours later and added the second bit in. Think the coffee is getting to me.