hierarchical/adjacency data for nested tree views/menus/ul lists

[eluser]sophistry[/eluser]
you'll have to restructure the database output to get it to match the format required by the function.

i suggest looking at the database docs in the manual and check out the result_array() method.