Hi, I am working with PHP and the PEAR Nested Set class.
There is the following table structure: id parent_id order_num level left_id right_id name 5 5 1 1 1 10 Root A 7 7 1 1 1 4 Root B 6 5 1 2 2 5 Sub1 of A 1 5 2 2 6 9 Sub2 of A 2 5 1 3 3 4 Child of Sub1 3 5 1 3 7 8 Child of Sub2 4 7 1 2 2 3 Sub of B When this tree is outputed as a menu structure it looks correct. I just don't understand why. Could anybody help me out here ? I know this isn't neccesarily a question for a mysql mailing list but maybe somebody is using the same structure. Thank you. Pete
