RE: [PHP] "Nested Set Model" or "modified preorder tree traversal"

2006-02-22 Thread Daevid Vincent
rom: Curt Zirzow [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 21, 2006 10:58 PM > To: php-general@lists.php.net > Subject: Re: [PHP] "Nested Set Model" or "modified preorder > tree traversal" > > On Tue, Feb 21, 2006 at 09:38:53PM -0800, Daevid Vincent w

RE: [PHP] "Nested Set Model" or "modified preorder tree traversal"

2006-02-22 Thread Jared Williams
Hi, As your using MySQL5, I'd recommend putting all the Nested Set code in stored procedures, that way the client doesn't need to know about anything about the method, and the left, right columns never need to be retrieved. Jared > I've been searching the web for the past few hours

Re: [PHP] "Nested Set Model" or "modified preorder tree traversal"

2006-02-21 Thread Curt Zirzow
On Tue, Feb 21, 2006 at 09:38:53PM -0800, Daevid Vincent wrote: > I've been searching the web for the past few hours trying to find a simple > drop-in class or functions to implement "Nested Set Model" or "modified > preorder tree traversal". I actually fell in love of this method of doing trees w

Re: [PHP] "Nested Set Model" or "modified preorder tree traversal"

2006-02-21 Thread Chris
Hasn't anyone else done this before (recently)? Did everyone just write their own code every time? Anyone have some easy to use code that allows for: Add, delete, update/rename, select, show tree, bread crumb display, etc. I use PHP 5.0.5 and mySQL 5.0.18, so ideally it would take advantage of a

[PHP] "Nested Set Model" or "modified preorder tree traversal"

2006-02-21 Thread Daevid Vincent
I've been searching the web for the past few hours trying to find a simple drop-in class or functions to implement "Nested Set Model" or "modified preorder tree traversal". I've found several tutorials and related links: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html http