Re: Unlimited Categories and Sub-Categories

Thanks, but how would I perform the select query? If possible, please include a code sample. Andrew digi-FX ------------------------------- http://www.digi-FX.net ----- Original Message ----- From: Robert J. Cissell <rcissell@tampabay.rr.com> To: Andrew <fisherres@msn.com>; PHP General <php-general@lists.php.net> Sent: Saturday, September 09, 2000 11:23 AM Subject: Re: [PHP] 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 > > > > > >