If that's really the query you're running, and if that's really the error from this query, then table 'friday' does not have a column 'employee'. It's plain and simple. If you do have a table Friday, and it does have a column employee, then either
1. This isn't really the query you're running. 2. That isn't really the error message from this query, it may be from another 3. Maybe you're in the wrong database?? ---John Holmes... > -----Original Message----- > From: Stephen [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 14, 2002 8:44 AM > To: PHP List; Owen Prime > Subject: Re: [PHP] Re: Odd Problem > > Here's one of the SQL's I'm running. All the rest are the same except they > each insert to different tables... > > $insertSQL = sprintf("INSERT INTO friday (`date`, employee, reg, over, > vac, hol, sick, funer, edu, per, comp) VALUES (%s, %s, %s, %s, %s, %s, %s, > %s, %s, %s, %s)", > GetSQLValueString($HTTP_POST_VARS['date'], "date"), > GetSQLValueString($HTTP_POST_VARS['user'], "text"), > GetSQLValueString($HTTP_POST_VARS['fri_reg'], > "text"), > GetSQLValueString($HTTP_POST_VARS['fri_over'], > "text"), > GetSQLValueString($HTTP_POST_VARS['fri_vac'], > "text"), > GetSQLValueString($HTTP_POST_VARS['fri_hol'], > "text"), > GetSQLValueString($HTTP_POST_VARS['fri_sick'], > "text"), > GetSQLValueString($HTTP_POST_VARS['fri_funer'], > "text"), > GetSQLValueString($HTTP_POST_VARS['fri_edu'], > "text"), > GetSQLValueString($HTTP_POST_VARS['tue_per'], > "text"), > GetSQLValueString($HTTP_POST_VARS['fri_comp'], > "text")); > > > ----- Original Message ----- > From: "Owen Prime" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, October 13, 2002 9:07 PM > Subject: [PHP] Re: Odd Problem > > > > If you showed us the SQL your trying to execute and the table schema you > may > > get more helpful responses. > > > > Cheers, > > > > Owen Prime > > http://www.noggin.com.au > > > > Stephen wrote: > > > > > Hello, > > > > > > I'm running a script that inserts a form's contents into a MySQL > table. > > > However, when I insert the contents, I get an error telling me this: > > > > > > Unknown column 'employee' in 'field list' > > > > > > I can't find the problem. I have a field in my table called employee > but > I > > > guess it doesn't see it. Any ideas why? > > > > > > Thanks, > > > Stephen Craton > > > http://www.melchior.us > > > http://php.melchior.us > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
