Duplicating categories

[gkd_uk]

I have created sub categories for countries around the world - see http://www.the-web-directory.co.uk/529/World/

What I want is something like Yahoo have setup - see Countries in the Yahoo! Directory

The way Yahoo Directory have it setup, is they have further categories within each country. Example Barbados in the Yahoo! Directory

I would like the same but don't want to manually type the sub categories into every country as it would take me ages to complete. Is there anyway of adding the sub categories manually for example into the United States category but then copying to all other categories? Can this be done by a SQL command

I know Bagi runs the same script so may be he'll know

Hope this makes sense

 

[Bagi Zoltán]

If I were you I would export the category table into csv format and create the subcategories with MS Excel manually. Once it is ready all you need to do is to delete the old table and import the csv file at the phpmyadmin page.

 

[gkd_uk]

Thanks for the quick repsonse Bagi

I will give this a try tonight but test it on another one of my directories just in case I get it wrong. I will make a backup also

Thanks once again

 

[OldWelshGuy]

What script is that?

 

[gkd_uk]

What script is that?

indexscript.com

 

[kaiz49]

By exporting the category you can create subcatogeries.This is one method.

__________________