Re: Parse Error on SQL Insert [Solved]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx]
> > Sent: 07 April 2006 20:53
> > To: php-general@xxxxxxxxxxxxx; tom@xxxxxxxxxxxxxx
> > Subject: Re:  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@xxxxxxxxxxxxxxxxxxx
> >
> > --
> > 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@xxxxxxxxxxxxxxxxxxx
>



--
Tom Chubb
tom@xxxxxxxxxxxxxx
07915 053312

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux