This post is a follow up to the discussion "Help with MySQL solutions for site navigation" that I started a few weeks ago. The problem was, how do I organize a multilevel site navigation hierarchy into a database? And from there, how do I output a nested unordered list? From suggestions here and other forums, and a helpful article at sitepoint I came up with the following solution.

In this approach I'm dealing with two concepts: Recursion, and the Modified Preorder Tree Traversal method, which I learned all about from an article at sitepoint. The article can explain both concepts a lot better than I can so I wont try.

I created a database for the example with the colums: id, label, level, lft, rgt

The data for the example is a 4 level site nav loosely based on a project I'm working on.

This is my first attempt at tackling this problem and if anybody has suggestions and I like to hear your ideas!

Thanks.

lol, actually I did, that's what this post is about. Follow the solution link and you'll see that your suggestion is exactly what I did. I'm hoping that it'll be helpful to others who are new to the whole php/mysql driven website concept. And I'm interested to see if anybody can spot ways to make my approach more efficient or if there is a simpler alternative.