[PHP-DB] Re: MySQL/PHP Iterative Tree

2002-11-27 Thread David Elliott
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greetings John On 26 November 2002 at 18:54:04 -0500 (which was 23:54 where I live) John W. Holmes wrote and made these points >> This is OK for some simple trees, however it does have some limitations. >> >> (1) Adding another tree / series of nodes

[PHP-DB] RE: MySQL/PHP Iterative Tree

2002-11-26 Thread John W. Holmes
> > You may want to check out using Nested Sets instead of a Parent-Child-ID > > system. > > This is OK for some simple trees, however it does have some limitations. > > (1) Adding another tree / series of nodes into the middle if the set. Not if you can define what the absolute max size of a no

Re: [PHP-DB] Re: MySQL/PHP Iterative Tree

2002-11-26 Thread Adam Voigt
A coworker suggested I just write either the array or the actual menu itself (in a .js file) at the time of category/subcategory creation and just include it on the page with the menu, which I suppose is what I must do since most other on-the-fly solutions seem fairly complicated and can get expone

[PHP-DB] Re: MySQL/PHP Iterative Tree

2002-11-26 Thread David Elliott
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello 1LT On 26 November 2002 at 09:54:57 -0500 (which was 14:54 where I live) 1LT John W. Holmes emanated these words of wisdom > You may want to check out using Nested Sets instead of a Parent-Child-ID > system. This is OK for some simple trees, h

Re: [PHP-DB] Re: MySQL/PHP Iterative Tree

2002-11-26 Thread 1LT John W. Holmes
t;[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 9:41 AM Subject: [PHP-DB] Re: MySQL/PHP Iterative Tree > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hello Adam > > On 26 November 2002 at 08:25:22 -0500 (which was 13:25 where I live) Adam > Voigt emanated these

[PHP-DB] Re: MySQL/PHP Iterative Tree

2002-11-26 Thread David Elliott
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Adam On 26 November 2002 at 08:25:22 -0500 (which was 13:25 where I live) Adam Voigt emanated these words of wisdom < ... > > Ok, and I am using this structure to make a kind of drill down > structure, so the top level would be where parentid