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.
> Thanks
> -- 
> Gerard Samuel

Raincross Technologies
Development and Consulting Services

Reply via email to