Spot on Bj. I am testing out why I can't get a script to work. I put straight values in and had - I thought - followed the manual (which doesn't show or mention quotes). I have a pulldown date part of a form (adapted from a SAMS book) to gather birthdays. The description is barebones in the book, and the pulldown is entered on page with <php? echo $date3->output(); ?>. But it won't work with <input> tags and I can't see how to call it to enter values in the table.
At the moment I am getting a blank page with no error information (I've cleaned up a number of errors before this) when I submit so I'm trying to check various parts of the script. In the script the $_POST[] calls do have quotes, so that is only my error in testing! Now I at least know the MySQL query works. Joseph Harris www.smilepoetryweekly.com ----- Original Message ----- From: "Bj" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, July 08, 2005 12:33 AM Subject: Re: [wdvltalk] How can this be an mysql column > 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.
