Hi DMX Team

Is there a tutorial for the "2 level dynamic nested menu"?

Any help is greatly appreciated.

Greetings

Willi

Edit: I've done a chat session with Miro who solved the problem. Thanks again. I can really recommend this service.

Edited by - Willi Schneider on 07 Sep 2010  18:24:21

Edited by - Willi Schneider on 07 Sep 2010  18:24:50

Hello,

As follow up here is a part from the Live support chat with Willi Shneider:

Quote

So in brief:
You need certain Database table structure. Like following - if you have 5 menu Items in the root and 3 of them have sub-items your table should have two columns - one for the root items and one for the subs each root item works as flag so in brief looking like this:

root item column | subitem column
-------------------------------------------
about | ---
products | product1
......... | ...........
producst | productN

so if you point out the root item column as flag column in UCNM GUI you will get root of ABOUT and PRODUCTS and PRODUCTS will have N pcs. Sub items named after the tems in the sub-item Column.

Miro can you provide an example mysql table???
Thanks
Chris

Hello,
I have tried several ways to handel with a 2 levels dynamic menu. (both levels are dynamic)
in my sample db is :
id item sub_item url
1 HOME index.php
2 ABOUT US NULL about-us.php
3 PRODUCTS NULL NULL
4 PRODUCTS Cd cd.php
5 PRODUCTS Memory memory.php
6 PRODUCTS Disk disk.php
7 CONTACT NULL contact.php
is it a correct structure ?
Then within UCNM
first level menu type is dynamic from record set, break is item, type is sub
second level menu type is dynamic from record set, break is item, type is sub. second level menu is put to the right in the structure.
the result is catastrophic as show here www.test.enchantant.be/test-menu.php
please help
Hervé

ps: windows xp sp3, dmx cs7, ucnm 1.0.5

here is a sample structure, I would suggest:

CategoryID tinyint(3) AI,primary
CategoryParent tinyint(3)
CategoryName varchar(50)

+---+---+--------------------------+
| 1 | 0 | Fruit |
+---+---+--------------------------+
| 2 | 0 | Vegetables |
+---+---+--------------------------+
| 3 | 1 | Apples |
+---+---+--------------------------+
| 4 | 1 | Peaches |
+---+---+--------------------------+
| 5 | 0 | Fish |
+---+---+--------------------------+
| 6 | 2 | Tomatos |
+---+---+--------------------------+
| 7 | 5 | Trouts |
+---+---+--------------------------+

How to use this with tables with relation?
Becous i cant get this none logic Menu Creater to work with 3 tables..... Help ASAP would be nice, els i will ask for refund, cos this according to the product info is that it should work with any recordset. But it does not!!!