Hi Anthony;
You describe your table as having the column 'subject'
You describe your SELECT query as having column 'subjet'
I do not know if the discrepancy is in your transcription to email only,
but if they are spelled differently in your actual query and table, you
may have a problem there.
Mike Hillyer
www.vbmysql.com
-----Original Message-----
From: Anthony Ward [mailto:awards@stripped]
Sent: Tuesday, May 27, 2003 8:34 AM
To: mysql@stripped
Subject: Select statement driving me crazy
Hi,
I'm tired of this statment i don't see where i'm wrong.
Anyhow,
here is what i have:
I have a table called testing
it has column
userid
email
subject
message
date
sendby
code
now I have a select statment on just few of this column not all.
SELECT userid,subjet,date,code FROM testing WHERE userid="testid"
There error is:
You have an error in your SQL syntax near userid,subject,date,code From
testing WHERE userid="testid" line1;
Now I don't see the error, any help is appreciated.
By the way, the statment is use in my program, which the language is
PERL,
so the actual statment is
$sth=$dbh->prepare(qq(SELECT userid,subjet,date,code FROM $table WHERE
userid="$testid"))
any help is well appreciated.
Anthony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
