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
