Re: Unlimited Categories and Sub-Categories

just set up a category table which includes at least these 3 fields: category_id - unique integer category name parent_category_id - integer which is the category id of whatever is above it > Hello, > > I'm creating a little something in PHP and I need some tips on creating > unlimited hierarchy/depth of categories using a mySQL database. Maybe > someone can provide me w/ some tips or code samples. A visual example is > below, and it'd be extremely easy to add more categories as one see's fit: > > cat 1 > | > sub cat 1 > sub cat 2 > | > sub sub cat 1 > cat 2 > cat 3 > | > sub cat 1 > > Thanks! > > Andrew > digi-FX > ------------------------------- > http://www.digi-FX.net > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >