Error in SQL query

Pellefant

Hello!

May I ask why this is wrong please, I have stared on it for a long time now without finding the error:

$Query = "INSERT INTO columns(approvedtime, datum, authortype, title, author, authoremail, writing, link1, link2, approved, clicks)
values ('0', '$datum', 'user', '$title', '$author', '$authoremail', '$writing', '$link1', '$link2', '0','0')" or die (mysql_error());

I get this terrible error msg:

You have an error in your SQL syntax near 'columns(approvedtime, datum, authortype, title, author, authoremail, writing, li' at line 1

This is the table data:

Field Type Attribut Null Standard Extra
id tinyint(4) Nej auto_increment

datum date Nej 0000-00-00

authortype varchar(80) Nej

title varchar(80) Nej

approvedtime bigint(20) Nej 0

author varchar(80) Nej

authoremail varchar(120) Ja NULL

writing text Nej

link1 varchar(120) Ja NULL

link2 varchar(120) Ja NULL

approved tinyint(3) Nej 0

clicks tinyint(6) Nej 0

YappyDog

You should not use the quotes around the zeroes when you put data into the int columns (approvedtime, approved, clicks). So, you should have:

$Query = "INSERT INTO columns(approvedtime, datum, authortype, title, author, authoremail, writing, link1, link2, approved, clicks)
values (0, '$datum', 'user', '$title', '$author', '$authoremail', '$writing', '$link1', '$link2', 0,0)" or die (mysql_error());

xblue

Hi again 🙂,

this one is simple, 'columns' is a reserved word, so rename your table.

for your bookmarks:
http://www.mysql.com/doc/en/Reserved_words.html

btw, mysql error returns the complete query from the point where it fails, so it may be very long, but you need to focus on the beginning only, this is most likely where the error is.

Pellefant

Thanks a lot for the help.

Page is added to bookmarks. 🙂