Okay, i'm doing the following:
$result = mysql_query("SELECT * FROM users WHERE alias = '$alias' and password = '$password'");
if ($row = mysql_fetch_array($result))
{
//yadda yadda yadda
//at this point the user has shown his alias and password are matches.
}
Basically checking for username and password.
However, the strange thing is that if the username/password are all lowercase (Such as 'sam') (and i suspect it would be the same in all upper case), It WORKS. If the case is mixed (such as 'sAm'), no match is found. I even echo the variables to make SURE they should be matching.
Both the entries in the table AND the variables are seemingly identical when I echo both side by side.
Anybody every experienced this? And how could I deal with it? I'm pretty new so this is fairly confusing 🙁
