Re: Parse Error on SQL Insert

Mi vote goes to the curly braces The error is given by php, not by SQL When exploding variables within double quotes it is hard for php to distinguish when a variable end unless it is a simple variable like $foo. When it is an array element and even worst, when it is an element of a multidimensional array, php cannot assert when it is over (really, it is not a bug, try to figure out how to do it and you'll see it is not easy) so you tell php by enclosing the whole variable in curly braces. Which it says so in the manual Satyam ----- Original Message ----- From: "Chrome" <admin@chrome.me.uk> To: "'Joe Henry'" <jhenry@celebrityaccess.com>; <php-general@lists.php.net>; <tom@ps-promo.co.uk> Sent: Friday, April 07, 2006 9:56 PM Subject: RE: [PHP] Parse Error on SQL Insert

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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php