amites Posted February 6, 2008 Share Posted February 6, 2008 hello, anyone know why this would be popping up an error? CREATE TABLE `item_position` ( `id` int(128) NOT NULL auto_increment, PRIMARY KEY (id), `userid` int(128) default NULL, `object0` text, `object1` text, `object2` text, `object3` text, `object4` text, `object5` text, `object6` text, `object7` text, `object8` text, `object9` text, `object10` text, `object11` text, `object12` text, `object13` text, `object14` text, `object15` text, `object16` text, `object17` text, `object18` text, `object19` text, `object20` text, `object21` text, `object22` text, `object23` text, `object24` text, `object25` text, `object26` text, `object27` text, `object28` text, `object29` text, `object30` text, `object31` text, `object32` text, `object33` text, `object34` text, `object35` text, `object36` text, `object37` text, `object38` text, `object39` text, `object40` text, `object41` text, `object42` text, `object43` text, `object44` text, `object45` text, `object46` text, `object47` text, `object48` text, `object49` text, `object50` text, `object51` text, `object52` text, `object53` text, `object54` text, `object55` text, `object56` text, `object57` text, `object58` text, `object59` text, `object60` text, `object61` text, `object62` text, `object63` text, `object64` text, `object65` text, `object66` text, `object67` text, `object68` text, `object69` text, `object70` text, `object71` text, `object72` text, `object73` text, `object74` text, `object75` text, `object76` text, `object77` text, `object78` text, `object79` text, `object80` text, `object81` text, `object82` text, `object83` text, `object84` text, `object85` text, `object86` text, `object87` text, `object88` text, `object89` text, `object90` text, `object91` text, `object92` text, `object93` text, `object94` text, `object95` text, `object96` text, `object97` text, `object98` text, `object99` text, `object100` text 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 '' at line 105 (last line) Quote Link to comment https://forums.phpfreaks.com/topic/89800-solved-mysql-query-syntax-error-help/ Share on other sites More sharing options...
kenrbnsn Posted February 6, 2008 Share Posted February 6, 2008 You're missing the terminating ");" Ken Quote Link to comment https://forums.phpfreaks.com/topic/89800-solved-mysql-query-syntax-error-help/#findComment-460152 Share on other sites More sharing options...
amites Posted February 6, 2008 Author Share Posted February 6, 2008 many thanks, knew it was staring me in the face Quote Link to comment https://forums.phpfreaks.com/topic/89800-solved-mysql-query-syntax-error-help/#findComment-460243 Share on other sites More sharing options...
revraz Posted February 6, 2008 Share Posted February 6, 2008 Or in this case, wasn't staring you in the face Quote Link to comment https://forums.phpfreaks.com/topic/89800-solved-mysql-query-syntax-error-help/#findComment-460250 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.