je voudrais créer un système de menu/sous-menus à partir d'une table sql que voici:
Code : Tout sélectionner
CREATE TABLE `jos_vm_category_xref` (
`category_parent_id` int(11) NOT NULL default '0',
`category_child_id` int(11) NOT NULL default '0',
`category_list` int(11) default NULL,
KEY `category_xref_category_parent_id` (`category_parent_id`),
KEY `category_xref_category_child_id` (`category_child_id`),
KEY `idx_category_xref_category_list` (`category_list`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Category child-parent relation list';
--
-- Contenu de la table `jos_vm_category_xref`
--
INSERT INTO `jos_vm_category_xref` (`category_parent_id`, `category_child_id`, `category_list`) VALUES (0, 1, NULL),
(0, 2, NULL),
(0, 3, NULL),
(0, 4, NULL),
(0, 5, NULL),
(0, 6, NULL),
(5, 55, NULL),
(27, 60, NULL),
(1, 12, NULL),
(1, 13, NULL),
(31, 78, NULL),
(1, 16, NULL),
(1, 17, NULL),
(1, 18, NULL),
(1, 19, NULL),
(2, 21, NULL),
(2, 22, NULL),
(2, 23, NULL),
(2, 24, NULL),
(3, 26, NULL),
(3, 27, NULL),
(3, 28, NULL),
(27, 29, NULL),
(4, 31, NULL),
(4, 32, NULL),
(4, 33, NULL),
(31, 77, NULL),
(4, 76, NULL),
(38, 86, NULL),
(5, 38, NULL),
(5, 39, NULL),
(5, 40, NULL),
(6, 41, NULL),
(2, 56, NULL),
(6, 43, NULL),
(6, 44, NULL),
(28, 61, NULL),
(33, 83, NULL),
(1, 50, NULL),
(0, 51, NULL),
(51, 52, NULL),
(52, 53, NULL),
(2, 57, NULL),
(2, 58, NULL),
(31, 79, NULL),
(32, 81, NULL),
(32, 80, NULL),
(31, 68, NULL),
(38, 69, NULL),
(5, 70, NULL),
(40, 71, NULL),
(39, 72, NULL),
(33, 82, NULL),
(2, 75, NULL),
(76, 84, NULL),
(76, 85, NULL),
(70, 87, NULL),
(55, 88, NULL),
(52, 89, NULL),
(28, 90, NULL),
(5, 172, NULL),
(28, 92, NULL),
(28, 93, NULL),
(0, 109, NULL),
(28, 103, NULL),
(0, 104, NULL),
(104, 105, NULL),
(104, 106, NULL),
(156, 157, NULL),
(26, 158, NULL),
(109, 110, NULL),
(109, 111, NULL),
(109, 112, NULL),
(110, 113, NULL),
(110, 114, NULL),
(111, 115, NULL),
(111, 116, NULL),
(112, 117, NULL),
(112, 118, NULL),
(110, 119, NULL),
(32, 120, NULL),
(27, 135, NULL),
(27, 136, NULL),
(3, 137, NULL),
(75, 131, NULL),
(75, 132, NULL),
(172, 173, NULL),
(3, 134, NULL),
(109, 138, NULL),
(138, 139, NULL),
(111, 140, NULL),
(109, 141, NULL),
(141, 142, NULL),
(1, 143, NULL),
(143, 144, NULL),
(143, 145, NULL),
(1, 146, NULL),
(146, 147, NULL),
(109, 148, NULL),
(148, 149, NULL),
(109, 150, NULL),
(150, 151, NULL),
(109, 152, NULL),
(152, 153, NULL),
(109, 0, NULL),
(109, 156, NULL),
(109, 0, NULL),
(109, 0, NULL),
(150, 155, NULL),
(26, 159, NULL),
(88, 160, NULL),
(71, 161, NULL),
(69, 162, NULL),
(88, 163, NULL),
(71, 164, NULL),
(69, 165, NULL),
(109, 166, NULL),
(166, 167, NULL),
(166, 168, NULL),
(57, 188, NULL),
(82, 170, NULL),
(82, 171, NULL),
(40, 174, NULL),
(38, 175, NULL),
(38, 176, NULL),
(40, 177, NULL),
(172, 178, NULL),
(1, 179, NULL),
(77, 196, NULL),
(1, 181, NULL),
(57, 182, NULL),
(57, 183, NULL),
(2, 184, NULL),
(1, 195, NULL),
(196, 197, NULL),
(77, 198, NULL),
(68, 194, NULL),
(198, 199, NULL),
(77, 200, NULL),
(200, 201, NULL),
(77, 202, NULL),
(202, 203, NULL),
(77, 204, NULL),
(204, 205, NULL),
(204, 206, NULL),
(77, 207, NULL),
(207, 208, NULL),
(77, 209, NULL),
(209, 210, NULL),
(207, 211, NULL),
(77, 212, NULL),
(212, 213, NULL),
(209, 215, NULL),
(212, 216, NULL),
(77, 217, NULL),
(217, 218, NULL),
(217, 219, NULL);
Merci pour vos réponses.
