Hello, I simply have a mysql problem, I'm trying to import a sql file, and I get this: ERROR 1064 (42000) at line 1: 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 'INSERT INTO games (gId, gInCategory, gSwfFile, gName, gOrder, gVisible, gThumb, ' at line 2 Well, it figures, but I'm not used to mysql errors so....any help
Well, I won't argue against 1064 being a syntax error, but you've only given us a portion of your SQL to see, so it's anybody's guess at this point. Care to share the entire SQL?
E.X> OF ALL OF THE SQL INSERT INTO games (gId, gInCategory, gSwfFile, gName, gOrder, gVisible, gThumb, gWidth, gHeight, gDescription, gplays, description2, des2, filetype) VALUES (20014,106,'20014.swf','Ultimate Dodgeball',0,1,'20014.png',0,0,'This ultimate dodgeball game consiss of 2 levels. Hit the opponent with the ball as hard as you can.',0,'','',1);
What version of MySQL are you running? Maybe it's moaning about the lack of `'s as in `column_name` as opposed to just column_name. Try this out: INSERT INTO `games` (`gId`, `gInCategory`, `gSwfFile`, `gName`, `gOrder`, `gVisible`, `gThumb`, `gWidth`, `gHeight`, `gDescription`, `gplays`, `description2`, `des2`, `filetype`) VALUES (20014,106,'20014.swf','Ultimate Dodgeball',0,1,'20014.png',0,0,'This ultimate dodgeball game consiss of 2 levels. Hit the opponent with the ball as hard as you can.',0,'','',1); If you're still not coming right with it then try posting your table structure with: show create table `games`; so we can try to replicate the problem.