Detailed info on creating dynamic menus
I need more detailed info on Creating Dynamic Menus. Your tutorials do not do a very good job of explaining this to the novice user. This is my MySql database:
CREATE TABLE IF NOT EXISTS `main_menu` (
`id_menu` int(11) NOT NULL AUTO_INCREMENT,
`parentID_menu` int(11) NOT NULL,
`label_menu` varchar(100) NOT NULL,
`link_menu` varchar(100) NOT NULL,
`target_menu` varchar(10) NOT NULL,
`highlight_menu` varchar(10) NOT NULL,
PRIMARY KEY (`id_menu`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `main_menu` (`id_menu`, `parentID_menu`, `label_menu`, `link_menu`,
`target_menu`, `highlight_menu`) VALUES
(1, 0, 'Home', '#', '_self', '1'),
(2, 0, 'Accessories', '#', '_self', '2'),
(3, 0, 'Products', '#', '_self', '3'),
(4, 0, 'Contact', '#', '_self', '4'),
(5, 2, 'Accessory1', '#', '_self', ''),
(6, 3, 'Product1', '#', '_self', ''),
(7, 3, 'Product2', '#', '_self', '');
I'm not sure how to set the sort and filter to get the results I need. I need to know how to sort and filter the top level of the menu as well as the second level and the third once it's been added to the database.
Any help you can give me with this issue would be greatly appreciated.