There is a tree based database system for menus and the like, but I can't quite remember what it's called or where I've seen it...
Anyone? Paul > Thanks for the info. The unmanageable part is probably more > to do with the > database design which, I feel, does not allow very much > flexibility. The > confusing aspect of the whole thing is when the end-user gets > hold of it > and tries to add a page it is quite complicated for them as > to where the > page will be located in the menu system. > > They can add a page that will either become the first page > when a category > is chosen or the first page in a menu, submenu or page > underneath a submenu. > > Below is the db tables that I am currently using: > > circuit (hold the main categories - top level) contains > amongst other fields: > contentid > menus (holds the main menus of each category) also contains > amongst other > fields: > contentid > submenus (hold sub-sections of the menus) > contentid > content (holds the content) > submenuid (which may be 0 if the contentid is linked > directly to > one of the above tables.) > > Ideally I want a system that doesn't care how many levels > there are in the > system. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
