[SOLVED] case sensitive query
Posted: Wed Sep 15, 2004 1:39 pm
Hello,
I'm running a query for user name and password. But, it works for both the CASES{ Lower case & Upper Case}. How do i check for CASE too.
Any help is really appreciated.
Here is the query.
I'm running a query for user name and password. But, it works for both the CASES{ Lower case & Upper Case}. How do i check for CASE too.
Any help is really appreciated.
Here is the query.
Code: Select all
$username = $_POST["name"];
$password = $_POST["pass"];
$result = MYSQL_QUERY("SELECT * from data WHERE UserName='$username' and PassWord='$password' ")
or die ("Name and password not found or not matched");