Find Exact Value...

[rIkLuNd]

I've got a little "problem" with my login script, and that is that it accepts the username, however it's written...

Let's say that my username is kiTTy; the db accepts it even if I write Kitty, kItTy etc... Is there anyway of checking the username so that it's only accepted when I write kiTTy?!

// Thanks

[jerdo]

If you are using MySQL you need to use the binary comparison, all other comparisons are case-insensitive. Something like this

$query = "SELECT username FROM usertable WHERE BINARY username='$_POST[username]'"

For a little more information you can go here http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html, or just post again.