sql - CategoryID/ParentCategoryID Looping Help -


how away generating tabbed list of categoryid/parentcategoryid simplest way? no sql expert, logically, difficult me..

can done 1 or 2 sql statements, maybe do/loop for/next work?

the list should this:

category -subcategory --subsubcategory ---infinitesubcategories

category -etc.. --etc...

read on thing called "closure tables". might make few things easier you.


Comments