Re: Parse Error on SQL Insert [Solved]
| From: | Tom Chubb | Date: | Sat, 08 Apr 2006 07:31:31 +0000 |
| Subject: | Re: Parse Error on SQL Insert [Solved] | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-233524@lists.php.net to get a copy of this message | ||
Sorry guys - knew it would be obvious!
I was using $_FILE['image']['name'][0], instead of
$_FILES['image']['name'][0]
However, thanks for all your help.
Tom
On 07/04/06, Joe Henry <jhenry@celebrityaccess.com> wrote:
>
> On Friday 07 April 2006 1:56 pm, Chrome wrote:
> > Backticks (`) encapsulate table or database names
> >
> > I was thinking maybe if the array references were encapsulated in curly
> > braces {}:
> >
> > $_POST['model'] to {$_POST['model']}
> >
> > Of course if the field in the DB isn't numeric this would be
> > '{$_POST['model']}'
> >
> > Dan
> >
> > -------------------
> > http://chrome.me.uk
> >
> >
> > -----Original Message-----
> > From: Joe Henry [mailto:jhenry@celebrityaccess.com]
> > Sent: 07 April 2006 20:53
> > To: php-general@lists.php.net; tom@ps-promo.co.uk
> > Subject: Re: [PHP] Parse Error on SQL Insert
> >
> > On Friday 07 April 2006 1:37 pm, Tom Chubb wrote:
> > > $insertSQL = "INSERT INTO cars (model,
year,
> > > details, price, image1,
> >
> > Not sure if this is your problem, but those look like backticks around
> year
> > instead of single quotes. Should there even be quotes there?
> >
> > HTH
> > --
> > Joe Henry
> > www.celebrityaccess.com
> > jhenry@celebrityaccess.com
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> > __________ NOD32 1.1475 (20060406) Information __________
> >
> > This message was checked by NOD32 antivirus system.
> > http://www.eset.com
>
> Good to know. Thanks.
>
> --
> Joe Henry
> www.celebrityaccess.com
> jhenry@celebrityaccess.com
>
--
Tom Chubb
tom@ps-promo.co.uk
07915 053312