aportando ideas
Código php:
Ver original$idval=$_GET['id'];
$sql = 'SELECT state FROM users WHERE id="'.$idval.'" LIMIT 1';
if (mysql_num_rows($result) <= 0){//verificamos que hay registro, si no existe lo mandamos al index echo 'Your Account Not Exist <a href="index.php">Return To Main Page</a>';
}else{
if ($row['state'] == 0){
echo 'Your Account its already activated <a href="index.php">Return To Main Page</a>';
}else{
// lo demas
}
}
// o con case
$idval=$_GET['id'];
$sql = 'SELECT state FROM users WHERE id="'.$idval.'" LIMIT 1';
switch($result['state']){
case 0:
echo 'Your Account its already activated <a href="index.php">Return To Main Page</a>';
break;
case 1:
//lo que sea que vaya
break;
default:
echo 'Your Account Not Exist <a href="index.php">Return To Main Page</a>'
}
espero y te sirva algo de aqui, saludos.