RE: [PHP] Parse Error on SQL Insert
| From: | Chrome | Date: | Fri, 07 Apr 2006 19:56:58 +0000 |
| Subject: | RE: [PHP] Parse Error on SQL Insert | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-233476@lists.php.net to get a copy of this message | ||
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