[PHP-DB] Re: nested sets?

2003-11-25 Thread 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

[PHP-DB] Re: nested sets?

2003-11-21 Thread 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