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) ) TYPE=MyISAM; 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. -Micah 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 > http://www.trini0.org:81/ > http://dev.trini0.org:81/ -- Raincross Technologies Development and Consulting Services http://www.raincross-tech.com
