thanks for the clarification, I guess the other solution would be to avoid using names with special meaning for column names...
-B

Ray Hauge wrote:

On Friday 07 April 2006 12:53, Joe Henry wrote:
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
[EMAIL PROTECTED]

The backticks should be fine. They tell MySQL that you mean the column "year" of the table "cars" and not the MySQL special word "year" which can be used in date calculations. The same thing would apply if you wanted a column named "create".

I would agree with John on the POST data. Make sure you at least run mysql_real_escape_string().


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

Reply via email to