Error 1054: Unknown column xxxx in WHERE clause..

[ndsoumah@gmail.com]

Hello Guys

I'm trying to run this query

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

and I get this error message : Error 1054: Unknown column 'xxxx' in
WHERE clause.....
where 'xxxx' is the content of $loginPassword

I don't know what is going on

Any help will be very appreciated.

Thanks.

[Tim Van Wassenhove]

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

On 2005-06-25, ndsoumah@gmail. com <ndsoumah@gmail .com> wrote:[color=blue]
> Hello Guys
>
> I'm trying to run this query
>
> $uneRequete = "SELECT * FROM Usager WHERE motDePasse =
> {$loginPassword }";
>
> and I get this error message : Error 1054: Unknown column 'xxxx' in
> WHERE clause.....
> where 'xxxx' is the content of $loginPassword[/color]

Arghl,

my guess is that you have $loginPassword = 'xxxx';

-> $uneRequete = "SELECT * FROM Usager WHERE motDePasse = xxxx";

Should be

-> $uneRequete = "SELECT * FROM Usager WHERE motDePasse = 'xxxx'";

--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be >

[ndsoumah@gmail.com]

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

Thanks for your reply Tim

But actually, anything I put in the WHERE clause generates the same
error.....even litterals. I don't know why he thinks it's a column!

[Oli Filth]

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

ndsoumah@gmail. com said the following on 25/06/2005 06:57:[color=blue]
> Hello Guys
>
> I'm trying to run this query
>
> $uneRequete = "SELECT * FROM Usager WHERE motDePasse =
> {$loginPassword }";
>
> and I get this error message : Error 1054: Unknown column 'xxxx' in
> WHERE clause.....
> where 'xxxx' is the content of $loginPassword
>
> I don't know what is going on
>[/color]

If you do echo $uneRequete;, what does it give?

--
Oli

[ndsoumah@gmail.com]

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

Thanks for your time oli.

I solved the problem. All I had to do was to place single quotes
around {$loginPassword }.