php mysql

[MeGa]

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

[Nightfire]

Do a query to see if it exists or not.

PHP Code:

$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

PHP Code:

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


[ReadMe.txt]

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

[Nightfire]

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