Case sensitive comparison

[proud]

I designed a login form and when the user logs in with his username and password I want to make sure that they are identical to the ones in the database (case sensitive), so I tried this code but it did not work; if you login with (jack) or (JACK) both are accepted.

 

 

	

$sql = "SELECT user_name FROM users WHERE STRCMP(user_name,'$userid') = 0
UNION
SELECT user_pass FROM users WHERE STRCMP(user_pass,'$password') = 0"; 

    $result=mysql_query($sql);
    $row = mysql_fetch_array( $result );

 

 

So is there any idea what is going wrong?

[tibberous]

$sql = "SELECT user_name, user_pass FROM users WHERE user_name='$userid', user_pass='$password'";

 

 

[proud]

 

This query just selects the username and the password but it doesnt check if they are both in the same case.

i.e (jack) and (JACK) will both be accepted by this query and that's not what I want.