I'm about to write a project that requires in-depth menus. About 4 levels.
How do I do this - the best way, the healthiest way for my database.
I was planning on using a table like this
pg_parent is the field that it is all about - if value is 0 - the page is parent, root. If the value is different, that value points to the page that is the root.

Now this seems like a good thing to do BUT how to generate this from database - seems there would be a big query to do this.
Your thoughts?

__________________
Back from sysadmins to the programmers.

That would be exactly how I would do it. Although the SQL would be rather extensive, if the pg_id's are all declared as indexes, then the query should be fairly quick. In any case, as the navigation links will not be changing daily, weekly, monthly or even yearly, then you can also introduce caching into the equation.

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

I was thinking about a "bootstrap", "compile" *.php file that will contain the data in precompiled arrays (one way of caching) - so no query for that.

Thanks Wildhoney, I have my ideas, but not sure if they are good.. :D

__________________
Back from sysadmins to the programmers.