Retrieve full category tree?? Help needed
Posted: Wed Feb 21, 2018 10:34 pm
Hi to all!!
I am in the early stage on developing a Mod. Its easy and simple, but i cant find a way to resolve a problem.
I need to fill a dropdown with the full category tree, like this:
- Category 1
- Category 1 - SubCat 1
- Category 1 - SubCat 2 - SubCat 1
- Category 2
And so...
I couldnt find an OC function for this, i also tried to code some php script, but i only achieved to get the full list of categories, without order and without a tree looking.
Is there an OC function y forgot?? Is there any Sql statement that could help me? I know the category_path table is there, but im completely stucked!!
Thanks in advance!
I am in the early stage on developing a Mod. Its easy and simple, but i cant find a way to resolve a problem.
I need to fill a dropdown with the full category tree, like this:
- Category 1
- Category 1 - SubCat 1
- Category 1 - SubCat 2 - SubCat 1
- Category 2
And so...
I couldnt find an OC function for this, i also tried to code some php script, but i only achieved to get the full list of categories, without order and without a tree looking.
Is there an OC function y forgot?? Is there any Sql statement that could help me? I know the category_path table is there, but im completely stucked!!
Thanks in advance!