Multiple level pages
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
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.
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.
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
|All times are GMT. The time now is 01:26 PM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0