ASP Menu driving me insane
- by simplesimon
Hi there,
I am trying to create a menu using ASP (I have never used ASP before, im a PHP man) using values stored in a database.
basically the html layout i want is as such:
<ul>
<li>
<ul class="sub-menu">
<li class="sub-menu-li">Test</li>
</ul>
</li>
</ul>
I need to loop around the root menu items rs("AD_Level") which is equal to 0 for root objects, then inside that loop, lop around anything that has the same parent id eg if the current record is AD_Level =0 and AD_Parent=5 then loop around all items with AD_Parent 5 and AD_Level != 0 and insert the values into html and so on and so forth.
Please help! I am struggling with a new language and cannot see a way to do this without losing sanity
Edit (Extracted from Comment by OP)
while not rsAdmin.eof
sPar = rsAdmin("ad_parent"
if rsAdmin("AD_Level")=0 then
while not rsAdmin2.eof
if rsAdmin2("AD_Level")<>0 and rsAdmin2("ad_parent")=sPar and rsAdmin2("AD_Sec_Level")=>2 then
response.write rsAdmin("AD_Menu")
end if
rsAdmin2.movenext
wend
end if
'' # if not rsAdmin.eof then sPar=rsAdmin("AD_parent") rsAdmin.movenext
wend
that is my code
