Re: 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" <owen@noggin.com.au> To: <php-general@lists.php.net> 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 > >