Need converted database. please help.

Hi all, I would like to convert a database that has raws like this:

INSERT INTO `games` VALUES (21337, 'Flash Chess 3D', '3D Flash Chess with great AI opponent', '21337', '100', 3, 1, '', '500', '500', '', '1');

Code (markup):

to a database that has the rows like this in it:

INSERT INTO `categories` (`catid`, `catname`, `catdesc`, `catkeywords`, `parentcatid`, `status`) VALUES (2, 'Sports', 'Sports Flash Games', 'sports,flash games,sport flash games', 0, 1);

Code (markup):

I', a dump when comes to databases.. please help. if anyone can to this for me, just tell me your price

 

I don't see enough information to suggest a good automated way of doing this.

I'd suggest populating your categories table with whichever categories you feel are apropriate and then adding each game to a category or categories.

If you want to script this, look at the UPDATE statement in SQL.

 

I can help you to get it done. I can do it on my machine and give you sql script.

thanks