Question about login?

[3D-kreativ]

Hi! I Use this code in the login process:

 

$query = "SELECT userName FROM {$tableUser} WHERE userName = '{$user}' AND userPassword = md5('{$password}')";

 

if($res->num_rows === 1) {
$_SESSION['accountUser'] = $row->userName;			
} else {

 

But I find it strange that I can log in with "user" despite that it's "User" in the table? But I can't use "password" it must be "Password". Could someone be kind to explain why and perhaps tell me how to fix this? Thanks!

[3D-kreativ]

I solved it after reading about COLLATE.