Re: MySQL/PHP Iterative Tree
| From: | David Elliott | Date: | Tue, 26 Nov 2002 16:07:59 +0000 |
| Subject: | Re: MySQL/PHP Iterative Tree | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23674@lists.php.net to get a copy of this message | ||
-----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, however it does have some limitations.
(1) Adding another tree / series of nodes into the middle if the set.
(2) A child node that belongs to more than one parent.
- --
Cheers, _______________________________________________
David | David Elliott | Software Engineer |
_________________________| david@elliott.uk.com | PGP Key ID 0x650F4534 |
| Mathematicians DO IT with sum. |
-----BEGIN PGP SIGNATURE-----
Version: 6.5.8ckt http://www.ipgpp.com/
iQA/AwUBPeOcYPmK8eZlD0U0EQJRVACfXZGjwwUlKOV1yEvtEf96D0MdNakAnAuF
PBlwh2HSenDKSVvldLp8H3fb
=QE8q
-----END PGP SIGNATURE-----