How do i make logging into my site case-sensitive? At the moment say if the username in mysql is 'Tim', and someone tries to log in with the username 'tim' it will let them.

Hi,

When your SQL queries the username and/or password values, I'm pretty sure your script does something along the lines of:

// assuming $_POST[username] is the field for hte username of the login form
$query = mysql_query("SELECT username FROM table WHERE username LIKE \"$_POST[username]\"");

It should use the equal = sign instead of LIKE keyword.

$query = mysql_query("SELECT username FROM table WHERE username=\"$_POST[username]\"");

I'm thinking this is the case one way or another. Obviously it won't be exactly the same, but this gives me a hunch. Hope this helps.

I found this for you. Although doing this for a login system will create more problems than it will solve.

Thank you, it took me a while but i found it, you have to use something like this:

PHP Code:

SELECT Name FROM users WHERE BINARY Name="Tim"