Hi there,

I have a situation where I would like to create unlimited categories, but going unlimited levels deep.... meaning something like:


level1 cat
|
level2 cat
|
level3 cat
|
unlimited

Is this possible? I can't seem to wrap my head around how to structure the database. If I didn't need unlimited levels, I would just create a table for each category and link it with a parent id type thing.

Is this possible? Or should I just throw in the towel and decide how many levels deep to allow for, and create a table for each one?

Thanks in advance.

Dk

yeah its possible

do a google on data hierarchies. I know theres some good stuff by Rudy Limeback (R937) with some SQL to retrieve upto 5 levels in one query hit

but dont' give up and try to create a table for each level.. that way the dark side lies

thanks healdem, it's here --> Categories and Subcategories