We have a big index of sites, each site belongs to a certain "main category"
and a sub_category.
Certain sites are nested inside 2,3 and even 5 sub-sub categories.
How can I create a category(ies) table(s) that will store the catID and catNAME?
(each category/subcategory ID takes 2 places xx)
Here is an Example:
The Yahoo! site, for example is in:
Computers and Internet > Internet > Internet and Search Engines > Directories > World
Where Computers and Internet = 24 00 00 00 00
(I've added space just to explain what I need)
Internet = 24 11 00 00 00
Internet and Search Engines = 24 11 92 00 00 00
Directories = 24 11 92 83 00 00
World = 24 11 92 83 00
Ofcourse there could be more then one sub-sub category named "world"
and the sub-sub count varies.
Any help, tips, something?
Michael.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
