Originally Posted by Old Pedant
The database structure you have chosen does not lend itself well to doing this kind of thing with MySQL (or any SQL for that matter).
Yes, you could do it in PHP, but since you will want to use JS to do the show/hide blocks you might as well do it all in JS.
Thanks for the info, in fact I have built one in jquery and ajax using the tables and it is working, however the person handling the project does not want it this way, and wanted only php to do the menus... The tables etc come from a custom made cms, done by another person, who is no longer maintaining the system while am using it only to dev websites from it