Outputting full hierarchy for child/parent relationshop table
Need help developing some code that will retrieve a full tree and leaf nodes with correct indentation based on the level, using a child parent relationship table setup. Currently i already have a script that does this, but i know it is probably the least efficient method out there. Here is a sample of the data:
To start, 0 means the top level, the start of the tree. So what this means is that categories 790 and 1 are main categories, and categories 64/72/80 are subcategories of 790 with category 83 being a sub category of 80... and so on.
So the kind of output i'd like is that if you're in say, category 83, the output would look like (though of course the id's swapped out for the category names):
790 64 72 80 83
As you can see, the output gives indentation to visually see the hierarchy.
Any help would be appreciated, thanks!
Well, unfortunately that is not an option at the moment. Currently i don't have enough time to attempt that, especially since it will only be to make the categories easier to program for, although i do agree.
So, any idea on how to do this with the existing adjacency model?