[PHP-DB] Re: nested sets?

[Hans Lellelid]

 You may want to try the famous Joe Celko's approach that he described in
 this book:

 Book review: SQL for Smarties
 http://www.phpclasses.org/products.html/id/1558605762.html

Also, be sure to check our the PEAR classes DB_NestedSet/MDB_NestedSet 
which will make using this model much, much easier.

But do buy the book, because it's awesome.

Cheers,
Hans
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: nested sets?

[Manuel Lemos]

Hello,

On 11/20/2003 12:28 PM, Ma wrote:
i try to make a clickable menu. it should be outputed as XML. i found a
solution to make it possible to decend only the selected menues. but is
there a easier solution?
my goal is to first show only the first (level=0) level. if the user clicks
on the menu it should select the second (level=1) level, but only from the
menu he clicked. (so HAVING level=1 doesn't help :( )
does anybody know a solution or a good reference for nested sets?
You may want to try the famous Joe Celko's approach that he described in 
this book:

Book review: SQL for Smarties
http://www.phpclasses.org/products.html/id/1558605762.html
If you do not want to reinvent the wheel, you may want to try this 
implementation:

Class: Joe Celko Nested Sets
http://www.phpclasses.org/celkonestedset
--

Regards,
Manuel Lemos
Free ready to use OOP components written in PHP
http://www.phpclasses.org/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php