otuatail Posted November 15, 2007 Share Posted November 15, 2007 Can't figure out why a simple insert is not working. Tearing hair out DROP TABLE IF EXISTS `news`; CREATE TABLE IF NOT EXISTS `news` ( `id` int(11) NOT NULL auto_increment, `Submitted` smallint(2) unsigned default NULL, `SubmitDate` int(4) unsigned default NULL, `content` text default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; INSERT INTO `news` VALUE ('', 3 , 1197996534 ,'Paul We are a team and we share everything'); #1064 - 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 'VALUE ('', 3 , 1197996534 ,'Paul We are a team and we share eve Link to comment https://forums.phpfreaks.com/topic/77521-solved-unknown-insert-error/ Share on other sites More sharing options...
otuatail Posted November 15, 2007 Author Share Posted November 15, 2007 Sorry Speeling error VALUES not VALUE Link to comment https://forums.phpfreaks.com/topic/77521-solved-unknown-insert-error/#findComment-392399 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.