Dynamic Menu -- Newbie

[Jim A]

Is there a way to load a menu's options based on classifications in the database?  I'd like to utilize this menu:  http://www.stunicholls.com/menu/pro_dropdown_2.html#nogo34

The Classifcations Table is the parent table.  If there are no child records, then I either want to leave that classification out of the menu, or disable it. 

Is it likely that this would bog things down a lot?  (I realize that this depends on the number of classifications.)

Thank you,

Jim

[ccordes]

Wow. Nice menu.
I have altered some things to use the Sucker Fish menus with some very nice results so I don't see why you couldn't use these.

In your page header procedure, just loop through your classification parent - child records to create the list structure.

Start with
packet = '<span class="preload1"></span>'&|
               '<span class="preload2"></span>' &|
                '<ul id="nav">'
do sendpacket
outside the loop

set(parent)
loop
      parent.next()
       if parent is done then break.
       packet = '<li class="top"><a href="' & clip(parent:href)&'" class="top_link"><span>Home</span></a>'       
      if child records exist
           packet = clip(packet)& '<ul class="sub">'
           loop
             child.next()
              if child is done then break.
              packet=clip(packet)& '<li><a href="'&clip(child:href)&' ">'&clip(child.menutext) &'</a></li> '
           end
           packet = clip(packet)& '</ul>' !close the list of children
      end
      packet = clip(packet) & '</ li>'   !close the parent
end
do sendpacket

... or something similar.

HTH,
chris c

[Jim A]

Hi Chris:  Been away from the project for a bit.  Just now found your  reply and help.  I will give it a try.

Many thanks,

Jim