Help with something MySQL.

[P10n33R]

Hello,

I was wondering if any one could point me to an easy way make this work. I want to be able to take a list of video games I have and put them into a MySQL database. The list is about 160 words long so I don't want to have to do it by hand. See below for code.

INSERT INTO `cheats` VALUES (19187, 1, 1, 5.0, '#gamename', '<p><h4>We currently do not have any cheats for #gamename, please check back. We will update this page soon.</h4></p>', 'XBox 360', '#firstletterofgame');

This is the database ID, I want it to increase by 1/insert line.
This is the name of the game. I want this to change twice per 'insert' I have.
This is the first letter of the game. I want it to pull from the #gamename if possible.

Please let me know what you think.

Thanks,
Michael Yuke

[jdk]

Is the games in a database or text file? If you send me the list of games I will write the code real quick and send it to you.

[P10n33R]

The games are in a text file. I now have two seperate lists for two seperate consoles, meaning the 'Xbox 360' part will also have to change.

[jdk]

If you wish to PM me both lists I will create this

[P10n33R]

Thank you, PM sent.

[jdk]

Done, files sent back to you. Let me know if you need anything else.