Re: Hierarchical List Question

yes. buy "SQL for Smarties" by Joe Celko, it's awesome. He's got a very unique method of dealing with nested trees. It's an XML approach instead of an id/parent_id approach which is the very traditional approach to dealing with nested tree. His approach offers incredible speed when searching through huge trees of items, and allows for very simple queries to extract information on the trees. If you're looking for a javascript based navigation system, you might take a look at: http://www.alchemy-computing.co.uk/joust/ You can dump a WDDX packet into it and it'll build your tree. It's pretty damn cool. Steve Nelson http://www.SecretAgents.com Tools for Fusebox Developers Clarence Kwei wrote: > > I'm trying to do write some code that will look through a table with an ID > and Parent_ID and create a hierarchical list of the results. > > ex. > > + Item 1 > - subItem 1.1 > - subItem 1.2 > - subItem 1.3 > - subItem 1.4 > - subsubItem 1.4.1 > - subsubItem 1.4.2 > - subsubItem 1.4.3 > + Item 2 > - subItem 2.1 > > etc. > > I've only seen one example on the web - a Javascript menu building function. > Does anyone know any other resources that might have some code that would do > the above. Any help would be greatly appreciated. > > Thanks very much. > > -- > > Clarence > > -> clarencek@ifurnishing.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net --