Creating a Hierarchical Structure
From: Gabriel Richards <grichards_at_endertechnology.com>
Date: Wed, 08 Aug 2001 16:49:25 GMT
Message-ID: <p4ec7.21643$Ug.5815984_at_typhoon.we.rr.com>
Date: Wed, 08 Aug 2001 16:49:25 GMT
Message-ID: <p4ec7.21643$Ug.5815984_at_typhoon.we.rr.com>
CategoryID ParentID Name 1 0 Shopping 2 1 Retail 3 1 Business to Business 4 2 Clothing
I was talking to some guy yesterday who said the standard what of creating such a system in a directory was to have a table which contains your root categories and then a new table for every level of sub-category. So if your directory goes 10 levels deep you have 10 category tables each containing the categories of a level.
What's better and why? What do you guys do?
Gabe
-- Ender Technology Web Applications, Design, Hosting http://www.endertechnology.com 310-516-7411Received on Wed Aug 08 2001 - 18:49:25 CEST