it's not in quotes, so... it must be a mySQL field name... mustn't it?
I think you have stayed up too late
Just put quotes round your string literals and you will get a few less
errors!
Bj
----- Original Message -----
From: "Joseph Harris" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, July 08, 2005 12:25 AM
Subject: [wdvltalk] How can this be an mysql column
Why, Oh, Why does this error come up in PHPmyAdmin; 'sam' is not in the
field list. Can anyone explain?
Error
SQL-query :
INSERT INTO loop_allname( first_n, last_n, email_address, birth,
countryID,
is_current )
VALUES (
sam, hams, '[EMAIL PROTECTED]', 19010630, 333, 1
)
MySQL said:
#1054 - Unknown column 'sam' in 'field list'
Joseph Harris
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To:
mailto:[EMAIL PROTECTED] or
use the web interface
http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
