INSERT should be perfect but returns an error

[phpgramma]

So here's my query:

$sql="INSERT INTO news (date,time,member_id,chapter_id,headline,article,show) VALUES ('$date','$time','$poster_id','$chapter_id','$headline','$article','$show')";

but for some reason I keep getting the error:
"You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near..."
and can't figure out why. I checked the database- fields are in the correct format and all of the variables, fields are named correctly in the statement...?

 

[sleipnir214]

It might be because you're using "show" and "date" as column names. SHOW and DATE are both MySQL reserved words.

You have two options:[ol][li]Pick better column names that don't use MySQL reserved words[/li][li]enclose those column names in backticks, which will let MySQL know they are not to be interpreted as reserved words[/li][/ol]

I strongly recommend the former.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[phpgramma]

oh yeah. duh. i forgot about that. thanks.