capital letters

[slimjim]

I have people submitting a form twice, one with lower case letters and one with capital letters.
Of course I have it checking to see if email is in DB, and this is their way of submitting twice.
Is there a way to prevent this by checking the DB for either lower case or upper case in a query ?
Or maybe they will even do both lower and upper case at same time.

Example :
[e-mail]
[e-mail]
[e-mail]

Many variations they try and succeed.

[konrad]

Try something like this, should work

<?php
 $qr = 'SELECT COUNT(*) FROM users WHERE LOWER(email) = "' . strtolower($submitted_email) . '"';
?>

Don't forget to perform submitted data against SQL injection before executing the query...

[slimjim]

that worked thank you