Search found 13 matches

by Milo
Wed Apr 23, 2008 9:36 am
Forum: Help & Support for DHTML Menu Version 5+
Topic: Dynamic menu items from a database
Replies: 33
Views: 45562

Re: Dynamic menu items from a database

I still have it, I get about 5 emails a week about doing this.. I don't mind, nice to see folk getting to grips with it.


http://01792.org/halo/template.asp?c=252

In the package,

Access database,
Classic asp page,
Install video.

Everything you need.
by Milo
Thu Apr 26, 2007 7:19 pm
Forum: Help & Support for DHTML Menu Version 5+
Topic: Dynamic menu items from a database
Replies: 33
Views: 45562

ASP + Access

I'm not suggesting you use access for big sites, but its a good demo.




http://01792.org
by Milo
Sun Jun 15, 2003 10:34 pm
Forum: Help & Support for DHTML Menu Version 5+
Topic: Dynamic menu items from a database
Replies: 33
Views: 45562

Application vars are a good point, there may be an issue with updating an application var, as this will momentarily lock the site, but that side a good idea. Was the point saying the menu wouldn't have to be drawn from the database each time? I think you might as "response.write" would have to be ...
by Milo
Thu Jun 12, 2003 12:09 pm
Forum: Help & Support for DHTML Menu Version 5+
Topic: Dynamic menu items from a database
Replies: 33
Views: 45562

I'll post a working version on the internet later on today, which outputs the ID into the menu, so you see more visually how the system hangs together.... the recursion isn't required as I "ORDER BY" the results, then if the parent (level) changes, I can assume there is a new submenu.

The example ...
by Milo
Wed Jun 11, 2003 9:23 pm
Forum: Help & Support for DHTML Menu Version 5+
Topic: Dynamic menu items from a database
Replies: 33
Views: 45562

The way the Jscript is structured it doesn't need the recursive function. It groups main menus, then ALL the sub menus. Not main menu1 then menu1 children, main menu2 then all menu2 children.

To be fair, that is how 90% of menus are structured. But not Milonic.

It works, as many sub menus as your ...
by Milo
Wed Jun 11, 2003 10:00 am
Forum: Help & Support for DHTML Menu Version 5+
Topic: Dynamic menu items from a database
Replies: 33
Views: 45562

DataBase driven example

I've knocked up a DB driven example. You can adapt for MySQL, MS-SQL2000 whatever you like.

This access version is good for 100 or so, co-current users, then performance will suffer.

Download from http://www.imadeitlast.com/temp/monmenu.zip

I haven't included any admin, if you require I can ...
by Milo
Tue Jun 10, 2003 1:20 pm
Forum: Help & Support for DHTML Menu Version 5+
Topic: Dynamic menu items from a database
Replies: 33
Views: 45562

Database driven menu

I've currently finished an ASP - SQL2000 driven menu. I run it off one table and one query.

The table will need at the minimum: -
ID (INT)
label (char or varchar - the text that appears on the page)
sub (BIT or Boolean - if true then it has submenus)
level (the parent link - for submenus only)
link ...