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) 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 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 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 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
Archived
This topic is now archived and is closed to further replies.