Re: Error 1054: Unknown column xxxx in WHERE clause..

[Russell Dyer]

I'm not exactly sure which API language you're using. However, I think my comments apply to any that this could be. The value in the WHERE clause should be in singe-quotes if it's a string. Otherwise, MySQL will assume the string it's passed is a column name and the table Usager probably won't have one by that name. I'm not sure what the point of the curly-braces are {}. You probably don't need them. So, your line of code should probably read like this:

$uneRequete = "SELECT * FROM Usager WHERE motDePasse = '$loginPassword'";

This should resolve the complaint about the unknown column. However, I suspect that you'll have another problem when you make that change. If the column motDePasse contains an encrypted password, you're going to have to use the same encryption method on the value of $loginPassword. That means that the line probably should look like this:

$uneRequete = "SELECT * FROM Usager WHERE motDePasse = PASSWORD('$loginPassword')";

Russell Dyer

Author of "MySQL in a Nutshell" (O'Reilly 2005).