-----BEGIN PGP SIGNED MESSAGE-----
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 = '0', then
> you take those id's and select from this table where parentid is
> equal to those id's, and now your starting to navigate through
> the tree, and so on.
> will let users of the site click on it, and then click on the submenu
> and down and down through all the level's that might dynamically exist,
Be careful of the size and the time it takes to build a big tree.
> but I can't for the life of me figure out how to recursively get the
> name and id for each row (which is what I need to build the menu and
> make link's out of each item), for as many sublevel's as there might be
> (infinite). Am I missing something, is there a simple logical way to do
> this recursively? Or if there's a semi-complex way, anyone got a script
> example? I'd very much appreciate it.
This is not much help but have done something like that in MSSQL with stored
procedure (about 120 to 150 lines of SQL).
The logic went something like.
get all top level
put into a temptable_1
go through temptable_1
put line into temptable_2 noting level
add on any children for line into temptable_2
next line of temptable_1
copy temptable_2 to temptable_1
keep going through temptable_1 until there is no more children at last level
I also used a separate table for the links this way it is easier to go both
up and down the tree.
What would be nice is to do it dynamically and display only the tree that
you need and just get the data for the children when needed. eg like MSDSon
David | David Elliott | Software Engineer |
_________________________| [EMAIL PROTECTED] | PGP Key ID 0x650F4534 |
| I am Barney of Borg...Sesame Street will be assimilated. |
-----BEGIN PGP SIGNATURE-----
Version: 6.5.8ckt http://www.ipgpp.com/
-----END PGP SIGNATURE-----
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php