Generate An Insert Query From This Page

[Brandon_R]

Hello guys im not exactly sure if this should go in the mysql or regex section so ill post in the mysql section first.

 

I need a code to generate an insert query from the following page:

 

http://www.sonyindex.com/Pages/PSP_US_Serial.htm

 

All the Game ID example ULUS-10310, UCUS-98601 should go in the row game_psp_id

All the Game Names example Twisted Metal - Head-On should go in the row game_name

The 3rd part is kinda tricky. I need to convert the U to a US and insert it in the row game_region

 

So in all the first query should look like this to properly insert the first line in the database:

 

mysql_query("INSERT INTO game_list

(game_name, game_psp_id, game_region) VALUES('Twisted Metal - Head-On

', 'UCUS-98601

', ' US' ) ")

or die(mysql_error());

 

dont worry about the auto_increment row because i already got that under. I need to insert all values with a game ID, game name and game region defined. As you can see on the page, some have game ID's but no game name etc you can skip those

 

Please Help

Brandon_R

 

 

 

 

 

[fenway]

Huh? What's the mysql question here?