Why won’t this send the user to user.php if the ID don’t exist in the table?
<?php include 'db_connect.php'; $id_exists = false; $url_id = mysql_real_escape_string($_GET['id']); $sql = "SELECT id FROM members WHERE id='$url_id'"; $result = mysql_query($sql); if ($result == $url_id) { $id_exists = true; } else if ($result != $url_id) { $id_exists = false; header("location:user.php"); exit(); } ?>
Advertisement
Answer
$url_id = mysql_real_escape_string($_GET['id']); $sql = "SELECT id FROM members WHERE id='$url_id'"; $result = mysql_query($sql); if(mysql_num_rows($result) >0){ //found }else{ //not found }
Try something like this :). http://php.net/manual/en/function.mysql-num-rows.php