where is the SQL table design
OK figured it - you do NOT need two tables to do multiple nesting - the setup below seems to work fine!
filter the root level on an entered value of 0
filter the rest/nested by fk_id_sec
and pass the URL dynamically with
/[url_sec]?id_sec=[id_sec]
in the LINK box
?id_sec=[id_sec] is there as I filter the page content by the section ID
-------------------------------------------------------------
Need to set up multiple level dynamic menu fast!!!!
where are the table and column definitions?
normally my navigation/section table is simple - with fk_id_sec keying to the id_sec of its parent - and being left 0 (zero) if it is in the root navigation list
ie
id_sec - fk_id_sec - title_sec
1 - 0 - Home
2 - 0 - About
3 - 0 - Contact
4 - 3 - ContactShop (Subsection of Contact)
5 - 4 - Shop Managers (Nested Subsection of ContactShop)
the documentation with this menu extension is really sketchy here and obviously takes a different approach
but its really not clear whats going on
CREATE TABLE `section_sec` (
`id_sec` int(11) NOT NULL auto_increment,
`fk_id_sec` int(11) default '0',
`title_sec` varchar(32) default NULL,
`url_sec` varchar(32) NOT NULL default 'index.php',
`page_title_sec` varchar(72) default NULL,
`meta_description_sec` varchar(255) default NULL,
`meta_keywords_sec` varchar(255) default NULL,
`order_sec` int(11) default NULL,
`publish_sec` int(11) NOT NULL default '1',
PRIMARY KEY (`id_sec`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=latin1
