Joe Lauzon Posted August 10, 2008 Share Posted August 10, 2008 My Query is... INSERT INTO jos_content (title, introtext, fulltext, sectionid, catid, created, created_by, modified, modified_by, publish_up, hits) VALUES ('test1', 'test2', 'test3', '1', '1', '2005-09-19', '65', '2005-09-19', '65', '2005-09-19', '2421'); The error message I get is... Insert New Data Query failed: 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, sectionid, catid, created, created_by, modified, modified_by, publish_' at line 1 I am sure I am just missing something stupid, but starting to see double trying to figure it out... Link to comment https://forums.phpfreaks.com/topic/118979-phpmysql-error-could-use-some-help-please/ Share on other sites More sharing options...
PFMaBiSmAd Posted August 10, 2008 Share Posted August 10, 2008 http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html Link to comment https://forums.phpfreaks.com/topic/118979-phpmysql-error-could-use-some-help-please/#findComment-612693 Share on other sites More sharing options...
fenway Posted August 11, 2008 Share Posted August 11, 2008 the column "fulltext" is the culprit. Link to comment https://forums.phpfreaks.com/topic/118979-phpmysql-error-could-use-some-help-please/#findComment-614083 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.