Get recursive menu from database

[eluser]Dam1an[/eluser]
[quote author="JoostV" date="1240789405"]Damian's solution does a seperate query on every parent to obtain its children. You could end up doing twenty or more queries just to fetch a single tree.

You might want to Google for 'adjacency list sql' or check out MPTtree: http://ellislab.com/forums/viewthread/74114/[/quote]

I never claimed my solution was perfect, but it gets the job done, and if/when performance ecomes an issue, its all a self contained function, so shoud be easy ehough to update...

Although I should really look into adjacency list sql lol