[PHP] Dynamic menu from DB

2003-01-09 Thread Cesar Aracena
Hi all, I'm making a new site for a client and he needs to put several different menus under a static FLASH menu. The bad part is that every item in the flash menu leads to different categories and these need different number of sub menus. I use MySQL PHP 4. The categories and sub categories are

Re: [PHP] Dynamic menu from DB

2003-01-09 Thread Marek Kilimajer
I don't know about the flash part, but submenus are simple. Your menu items table needs a parent column, where the id of the parent menu item, but for top level menus (Flash static menu) it will be 0. Then first select all menu items with parent=0 and as you loop throught the result result,