[Resolved] INSERT INTO Problems

[Kol]

Hi there...

Im having problems inserting data into my database.

Here is my query:

$result = mysql_query("INSERT INTO events (sort_date,name,key,date) VALUES ($sort_date,$item_event_name,$item_event_key,$date)");

And here is the error i get:

You have an error in your SQL syntax near 'key,date) VALUES ($sort_date,$item_event_name,$item_event_key,$date)' at line 1

Does anyone have any ideas why?

Thanks!

Dave

[barand]

You are using reserved words as field names. Place backticks around key and date.

INSERT INTO events (sort_date,name,key,date) VALUES ($sort_date,$item_event_name,$item_event_key,$date
)");

[Kol]

WOOOOOOOHHHOOOOOOOOOOOO

Thanks. Thats great. I have just spent the best part of an hour trying to get that to work :eek:

Thanks again!

Kol

[drawmack]

please click on resolved below to mark this thread as resolved.