sneamia Posted November 13, 2007 Share Posted November 13, 2007 INSERT INTO `news` (origID, title, summary, fulltext, timestamp, timestamp2, author, ip) VALUES (3, 'title of it', 'summary of it', 'full text of it', 1194919992, 1194919992, 'loladmin', '68.193.xx.xx') Fatal 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 'fulltext, timestamp, timestamp2, author, ip) VALUES (3, 'title of it', 'summary ' at line 1 newsID - smallint(6) - auto_increment, primary key origID - smallint(6) title - varchar(50) summary - text fulltext - mediumtext timestamp - int(10) timestamp2 - int(10) author - varchar(20) ip - varchar(16) What am I doing wrong? I hate these cryptic MySQL errors. Quote Link to comment https://forums.phpfreaks.com/topic/77083-solved-fatal-error-you-have-an-error-in-your-sql-syntax/ Share on other sites More sharing options...
toplay Posted November 13, 2007 Share Posted November 13, 2007 fulltext is probably a reserved word in MySQL so enclose that column name in back tick marks i.e. `fulltext` You might just want to do that to all your column names anyway. Quote Link to comment https://forums.phpfreaks.com/topic/77083-solved-fatal-error-you-have-an-error-in-your-sql-syntax/#findComment-390377 Share on other sites More sharing options...
sneamia Posted November 13, 2007 Author Share Posted November 13, 2007 fulltext is probably a reserved word in MySQL so enclose that column name in back tick marks i.e. `fulltext` You might just want to do that to all your column names anyway. I stuck the tickmarks in later, but I didn't know about the fulltext part. Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/77083-solved-fatal-error-you-have-an-error-in-your-sql-syntax/#findComment-390402 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.