RE: Parse Error on SQL Insert

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

 



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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[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