473,320 Members | 2,180 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Error 1054: Unknown column xxxx in WHERE clause..

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.

Jul 17 '05 #1
4 9841
On 2005-06-25, nd******@gmail.com <nd******@gmail.com> wrote:
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


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>
Jul 17 '05 #2
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!

Jul 17 '05 #3
nd******@gmail.com said the following on 25/06/2005 06:57:
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


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

--
Oli
Jul 17 '05 #4
Thanks for your time oli.

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

Jul 17 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Navin | last post by:
Ado Sort -Relate, Compute By, or Sort operations cannot be done on column(s) whose key length is unknown or exceeds 10 KB. hi, guys i have asp application running on iis 5.0 windows 2000 i use...
7
by: Egyd Csaba | last post by:
Hi, I've a problem with some of my stored procs. My config is: RH7.1, Postgres 7.3.2 I had converted a few fields of a few tables from one type to another and after this I made all the...
7
by: Gb | last post by:
Hi There, I have: select myTable.*, Case When myTable.problem_CLOSE_date = myTable.problem_creation_date then 2 When myTable.problem_CLOSE_date >0 and myTable.problem_status='C' then 3...
5
by: Bob Sparks | last post by:
I upgraded to stinger and got stung. Not all my code compiles. Most of the problems are stinger seems to be more stringent on casting varchars to vargraphics. This I am working out, however, one...
6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
102
by: Skybuck Flying | last post by:
Sometime ago on the comp.lang.c, I saw a teacher's post asking why C compilers produce so many error messages as soon as a closing bracket is missing. The response was simply because the compiler...
669
by: Xah Lee | last post by:
in March, i posted a essay “What is Expressiveness in a Computer Language”, archived at: http://xahlee.org/perl-python/what_is_expresiveness.html I was informed then that there is a academic...
5
by: Larry in Honolulu | last post by:
I'm getting an error message that makes no sense to me. I have a table with a field named 'testkey' for a list of "keys" in the form of ABC10102. I have a php variable holding a specific key...
3
by: benicio | last post by:
Database query failed: Unknown column 'subj' in 'where clause' What does this error mean and how should it be fix?
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shllpp 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.