[joeroberts]

just to help out here are a few sample sub cats to get you started and give you a Idea on how to do it

INSERT INTO `categories` (catid, name, subname)VALUES(6, 'Anime', 'About a Girl');
INSERT INTO `categories` (catid, name, subname)VALUES(6, 'Anime', 'AMV');
INSERT INTO `categories` (catid, name, subname)VALUES(6, 'Anime', 'Battle Programer Shirase');
INSERT INTO `categories` (catid, name, subname)VALUES(6, 'Anime', 'Big O');
INSERT INTO `categories` (catid, name, subname)VALUES(1, 'Movies', 'Action');
INSERT INTO `categories` (catid, name, subname)VALUES(1, 'Movies', 'Adventure');
INSERT INTO `categories` (catid, name, subname)VALUES(1, 'Movies', 'Americana');
INSERT INTO `categories` (catid, name, subname)VALUES(1, 'Movies', 'Animation');
INSERT INTO `categories` (catid, name, subname)VALUES(4, 'Games', 'Dreamcast');
INSERT INTO `categories` (catid, name, subname)VALUES(4, 'Games', 'Game fixes/patches');
INSERT INTO `categories` (catid, name, subname)VALUES(4, 'Games', 'GameCube');
INSERT INTO `categories` (catid, name, subname)VALUES(4, 'Games', 'Linux');
INSERT INTO `categories` (catid, name, subname)VALUES(3, 'Music', 'Alternative');
INSERT INTO `categories` (catid, name, subname)VALUES(3, 'Music', 'Ambient');
INSERT INTO `categories` (catid, name, subname)VALUES(3, 'Music', 'Anime');
INSERT INTO `categories` (catid, name, subname)VALUES(3, 'Music', 'Asian');
INSERT INTO `categories` (catid, name, subname)VALUES(5, 'Appz', 'Linux');
INSERT INTO `categories` (catid, name, subname)VALUES(5, 'Appz', 'Mac');
INSERT INTO `categories` (catid, name, subname)VALUES(5, 'Appz', 'Mobile phones');
INSERT INTO `categories` (catid, name, subname)VALUES(5, 'Appz', 'Other operating systems');
INSERT INTO `categories` (catid, name, subname)VALUES(2, 'Shows', '10 Items or Less');
INSERT INTO `categories` (catid, name, subname)VALUES(2, 'Shows', '24');
INSERT INTO `categories` (catid, name, subname)VALUES(2, 'Shows', '3 LBS');
INSERT INTO `categories` (catid, name, subname)VALUES(2, 'Shows', '30 Days');
INSERT INTO `categories` (catid, name, subname)VALUES(7, 'Others', 'Flash/Shockwave');
INSERT INTO `categories` (catid, name, subname)VALUES(7, 'Others', 'Funny clips');
INSERT INTO `categories` (catid, name, subname)VALUES(7, 'Others', 'Other');
INSERT INTO `categories` (catid, name, subname)VALUES(7, 'Others', 'Podcasts');

to give you example on how to write new sql, the values are:

PHP Code:

INSERT INTO `categories` (catid, name, subname)VALUES(7, 'Others', 'Podcasts'); 


7 is the id of the base category

the Others are the name of the base category

Podcasts is the name of the new subcategory you want to add the the Others category