Help with something MySQL.

P10n33R · 05-20-2006, 05:26 PM

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.
????: NamePros.com http://www.namepros.com/programming/199401-help-with-something-mysql.html

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

I have someone helping me know.

Thanks all.

jdk · 05-25-2006, 10:18 PM

Job was completed.

05-20-2006, 05:26 PM	THREAD STARTER #1 (permalink)
P10n33R Senior Member Join Date: Aug 2004 Location: Ontario, Canada Posts: 1,238	Help with something MySQL. 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. ????: NamePros.com http://www.namepros.com/programming/199401-help-with-something-mysql.html 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 I have someone helping me know. Thanks all. Last edited by P10n33R; 05-20-2006 at 06:09 PM.

05-25-2006, 10:18 PM	#2 (permalink)
jdk Senior Member Join Date: Jul 2004 Location: Florida Posts: 1,492	Job was completed.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)