first of all I am sory for my english.
My category structure is shown below. My purpose is to get category structure with single query. I sort my table by path and I get category tree.
sort_order : Indicates sort order between categories with same level
When I run query
SELECT * FROM category order by path;
RESULT:
But result must be as shown below because sort_order of Electronic is 1 and this is less than sort_order value of Computer category 2
- ELectronic
- - TV
- - - LCD
- - - - LED LCD
- Computer
- - Laptop
EDIT :
For @adopilot
Query : SELECT * FROM category order by level, path;
RESULT: