Re: Parse Error on SQL Insert [Solved]

From: 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

« previous php.general (#233524) next »