Question,

I am attempting to check for if user has registered before, by comparing the email at login with the one in the db. The process below works, but I found a problem. If the case of the input is different, the db registers it as a new user. (example: anyone@this.com, and Anyone@this.com, or anyOne@this.com) are accepted as different users. How can I get my code to do and exact comparison, without the case sensitivity?

This is what I have now:

$abs = mysql_fetch_array($rs) ;

while($result = mysql_fetch_array($rs))
		{
if($result['email'] == $mail)
	{
		header("location: freesignup2.htm"); exit();
	}
}

You can convert both strings into lower case using strtolower() and then compare the lower case versions:

PHP Code:

$abs = mysql_fetch_array($rs) ;

while($result = mysql_fetch_array($rs))
        {
if(strtolower($result['email']) == strtolower($mail))
    {
        header("location: freesignup2.htm"); exit();
    }
} 


It still seeing the difference and lording it into the db.