Re: If ID does not exist? (PHP)

[bungle]

In order to provide the latter functionality as crgeary says, when a user deletes their profile, you would really want to mark their user ids record as inactive rather than deleting it. I would add a boolean field of ‘active’ to the user table and then you can do a check like this to see what you are dealing with:

$id  = mysql_real_escape_string($_GET);

$sql = "SELECT * FROM users WHERE id=$id";

$result = mysql_query($sql);



if (mysql_num_rows($result)==0) {

echo ('User never existed');

}

else if (mysql_num_rows($result)==1) {

$userinfo = mysql_fetch_array($result);

if (!$userinfo) {

echo ('User no longer exists.');

}

else {

echo ('User exists and is active.')

}

}

?>