av arcade and mySQL

ok i am a newbe to mySQL i am tring to put to gether a game pack for av arcade

here is mycode

INSERT INTO `ava_cats` VALUES (100, 'Adventure');

INSERT INTO `ava_cats` VALUES (101, 'Shooting');

INSERT INTO `ava_cats` VALUES (102, 'Other');

INSERT INTO `ava_cats` VALUES (103, 'Sports');

INSERT INTO `ava_cats` VALUES (104, 'Shooting');

INSERT INTO `ava_cats` VALUES (105, 'RPG');


INSERT INTO `ava_games` VALUES (221, 'Treasure Seas', 'You are searching for treasure in your submarine. Avoid the sharks!', '221', '100', 3, 1, '', '500', '500', '', '1', '1');
INSERT INTO `ava_games` VALUES (222, 'Dodo Hunt', 'Simple! Just find the Dodo', '224', '100', 1, 1, '', '500', '500', '', '1', '1');
INSERT INTO `ava_games` VALUES (223, 'Hungry Fish', 'Youre a fish that is very hungry. You have to eat something!', '223', '100', 2, 1, '', '500', '500', '', '1', '1');
INSERT INTO `ava_games` VALUES (224, ' Poink', 'How fast are you how many can you hit!!', '224', '102', 3, 1, '', '500', '500', '', '1', '1');
NSERT INTO `ava_games` VALUES (225, '  Ultimate Mega Hoops', 'A simple basketball game', '225', '103', 3, 1, '', '500', '500', '', '1', '1');

Code (markup):

This what i get when i try to inport the file in phpmyadmin

any one have any idears

thank you for your help

 

anyone ??????

 

it simple...

go to ava_games , browse it with phpMyAdmin change the key 1 to whatever ... 422 or dunno ... just change it because the new game pack has also a "key nr. 1"

hope you manage to do it ... if not , pm me ! i help u

KriSs

 

Actually go to ava_cats and check the entry with key 100
You already have those categories filled up

 

Check to see if those columns have auto increment and if so replace the id with '' instead.

example:

INSERT INTO `ava_cats` VALUES ('', 'Adventure');