I have a mysql table for my menu data. each menu item has a field that cotains it's parent ID field. i used ZERO (0) for top level items... i wanna create a multi level dynamic menu using my table data! i can't do that . my problem is related to loops... please help me and suggest a sample code!
Code: Select all
CREATE TABLE IF NOT EXISTS `sitemap` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parentId` int(11) DEFAULT '0',
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;thank you
mansour