Cell Phones - Internet Advertising - Credit Card Application - Military Videos - Credit

PDA

View Full Version : Can someone help,, mysql error when inserting


q8uwait
Oct 15th 2007, 12:50 am
Hello,

Everytime I try to import this sql code

INSERT INTO `games` (`gId` ,`gInCategory` ,`gSwfFile` ,`gName` ,`gOrder` ,`gVisible` ,`gThumb` ,`gWidth` ,`gHeight` ,`gDescription` ,`gplays` ,`description2` ,`sponsor_name` ,`sponsor_link`) VALUES (2,101,'1221.swf','12 Many',0,1,'1221.png',480,360,'The screen flashes quickly and it ask you how many stars you seen. Can get quite challenging.',0,'','',''),

I get the following error

MySQL said:

#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 '' at line 1


Is there is any problems with the code above.

Thanks

SirBlogger
Oct 15th 2007, 1:34 am
the comma at the end could be a problem if there is no code after it..

it career
Oct 15th 2007, 1:40 am
Hello,

Everytime I try to import this sql code

INSERT INTO `games` (`gId` ,`gInCategory` ,`gSwfFile` ,`gName` ,`gOrder` ,`gVisible` ,`gThumb` ,`gWidth` ,`gHeight` ,`gDescription` ,`gplays` ,`description2` ,`sponsor_name` ,`sponsor_link`) VALUES (2,101,'1221.swf','12 Many',0,1,'1221.png',480,360,'The screen flashes quickly and it ask you how many stars you seen. Can get quite challenging.',0,'','',''),

I get the following error

MySQL said:

#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 '' at line 1


Is there is any problems with the code above.

Thanks
Replace last , after ) by ; and check

q8uwait
Oct 15th 2007, 2:30 am
Thanks that worked great .. was the comma