Re: SQL Error
| From: | Steve Fitzgerald | Date: | Thu, 02 Aug 2001 13:44:45 +0000 |
| Subject: | Re: SQL Error | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10996@lists.php.net to get a copy of this message | ||
It was the comma after $CompanyID that caused the problem. (Duh!)
Thanks.
"Johannes Janson" <johannes.janson@gmx.de> wrote in message
news:20010802133915.3092.qmail@pb1.pair.com...
> Hi,
>
> [...]
> > Any ideas?
> >
> > $add_contact_sql = "INSERT INTO $table_name
> > (ContactID, FirstName, LastName, Title, WorkPhone,
> > HomePhone,Mobile,EmailName,Birthday,CompanyID)
> > VALUES
> > ('',
> > '$FirstName',
> > '$LastName',
> > '$Title',
> > '$WorkPhone',
> > '$HomePhone',
> > '$Mobile',
> > '$EmailName',
> > '$Birthday',
> > '$ContactID',
>
> is that comma really there??? if so this might be the problem.
>
> > )";
>
> cheers
> johannes
>
>