Re: Nested Set Model in mySQL DB

2004-05-25 Thread Jigal van Hemert
> 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

Nested Set Model in mySQL DB

2004-05-25 Thread Björn Weiß
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 S