I have a quick question I am rebuilding a directory and have a bunch of new Top categories then subcategories then more sub categories to add to them for instance Counties --Cities --- Business Categories is there an easy way to do it as right now I put the counties in then add the cities by way of the add subcategory button then I have to go to each city and add 65 more categories please does anyone have a suggestion that might work better
You could write the SQL code and just paste it each time, changing only the value for the parent category.
but wouldn't the other category number change also for instance Parent Cat 5123 then Sub cat 5124 then 65 categories under the subcat and how would I go about writing it just pull phpld sql code and go from there or what as right now I have all the counties and cities in one text file and the other 65 categories in another text file
Assume you added UK > London to the database. London has the ID 15. You could write the SQL code to add your 65 standard categories with a parent ID of 15. Then your 65 categories would become sub-categories of London.
ah ok I get it go ahead and add all the counties (top cats) and cities (sub cats) then add the 65 cats to the cities by way of a mysql thanks Mike tried to add rep but it said I had to pass some around first