Posted by amygdala on 06/06/07 16:54

"Steve" <StevePBurgess@gmail.com> schreef in bericht
news:1181135483.395148.227430@p77g2000hsh.googlegroups.com...
>I have been studying the Adjacency List Model as a means of achieving
> a folder structure in a project I am working on. Started with the
> excellent article by Gijs Van Tulder
>
> http://www.sitepoint.com/article/hierarchical-data-database
>
> My database has this basic structure:
>
> Id
> FolderName
> ChildOf
>
> where ChildOf is the Id of the Folder that the current folder is
> nested within.
>
> Although I can use this to make indented text lists - I want the
> output to be a hierarchical HTML structured list using <ol><li>
> structures.
>
> So, for example, my folders are:
>
> News
> -Government Information
> -BBC
> -National Press
> Books
> LIS
> -UKEIG
> -NPRIE
>
> I want the output to be:
>
> <ol>
> <li>News
> <ol>
> <li>Government Information</li>
> <li>BBC></li>
> <li>National Press</li>
> </ol>
> </li>
> <li>Books</li>
> <li>LIS
> <ol>
> <li>UKEIG</li>
> <li>NPRIE</li>
> </ol>
> </li>
> </ol>
>
> and for this to work irrespective of the number of levels in the
> hierarchy.
>
> Any ideas?
>

Recursion my friend. I've done something simular recently, but a bit
verbose; in every recursion I used an SQL query.

However, yesterday I stumbled across an example that does the job far more
efficient:

http://www.tagarga.com/blok/on/061029

Courtesy of newsgroup contributor gosha bine.

HTH

[Back to original message]