[SOLVED] how comes this code is being ignored?

[merylvingien]

else
  {


         $sql=("SELECT email, ipaddress FROM table");
	$result = mysql_query($sql);
$row = mysql_fetch_array($result);

if($row['email'] == $email) {echo 'error message'; include("foot.html"); exit;}
if($row['ipaddress'] == $ipAddress) {echo 'error meassage'; include("foot.html"); exit;}
}

 

For some reason this code is being bypassed and even if the email address and ipaddress is already in the database it still goes forth and registers a user for a second time. Am i missing something?

[rajivgonsalves]

there is no where clause in your select query 

[merylvingien]

I wasnt aware that i needed a where clause, can i not just select all the emails from the database and all the ipaddress's and check them?

[rajivgonsalves]

I think your better off only checking email addresses

 

sorry made a mistake

$sql= "SELECT email FROM table where email = '{$email}' ";
      $result = mysql_query($sql);

if(mysql_num_rows($result) > 0) {echo 'error message'; include("foot.html"); exit;}

[merylvingien]

Ok i fixed that now, many thanks.

 

I have to check ip's becuase the same people are signing up with different email addresses. Cheaters LOL