Use the parent/child relationship thing:
CREATE TABLE Categories (
CategoryID int(11) NOT NULL auto_increment,
ParentID int(11) NOT NULL default '0',
Category_Name tinytext NOT NULL,
PRIMARY KEY (CategoryID)
So at each level you can find the subcategories by:
SELECT * FROM Category WHERE ParentID = $This_Level_ID;
The top level would have a ParentID of 0.
*shrug* - One way to do it.
On Mon, 2003-01-13 at 21:32, Gerard Samuel wrote:
> Im figuring this is more of an sql question than anything else.
> I'm trying to figure out a table structure to create unlimited depths of
> categorical data.
> I've done something for category/subcategories before, but haven't an
> idea how to create categories at an unlimited depth.
> Any pointers would be greatly appreciated.
> Gerard Samuel
Development and Consulting Services