假设你是用asp操作,且一级菜单字段m1, 二级菜单m2
sql 语句可以这样写:先查一级菜单m1, 得结果集r1 ; 嵌套查询二级菜单m2, 得结果集r2
<%
...
已查得r1
...
i = 1
do while not r1.eof
%>
<div class="menutitle" onclick="SwitchMenu('sub<%=i%>')"><%=r1("m1")%></div>
<%
' 查询r2
sql = "..."
r2.open sql, ....
%>
<span class="submenu" id="sub4">
do while not r2.eof
%>
<%
r2.movenext
loop
r2.close
r1.movenext
loop
%>
sql 语句可以这样写:先查一级菜单m1, 得结果集r1 ; 嵌套查询二级菜单m2, 得结果集r2
<%
...
已查得r1
...
i = 1
do while not r1.eof
%>
<div class="menutitle" onclick="SwitchMenu('sub<%=i%>')"><%=r1("m1")%></div>
<%
' 查询r2
sql = "..."
r2.open sql, ....
%>
<span class="submenu" id="sub4">
do while not r2.eof
%>
<%
r2.movenext
loop
r2.close
r1.movenext
loop
%>
-------------------------
假设你是用asp操作,且一级菜单字段m1, 二级菜单m2
sql 语句可以这样写:先查一级菜单m1, 得结果集r1 ; 嵌套查询二级菜单m2, 得结果集r2
<%
...
已查得r1
...
i = 1
do while not r1.eof
%>
<div class="menutitle" onclick="SwitchMenu('sub<%=i%>')"><%=r1("m1")%></div>
<%
' 查询r2
sql = "..."
r2.open sql, ....
%>
<span class="submenu" id="sub<%=i%>">
do while not r2.eof
%>
-<a href="<%=r2("m2")%>"><%=r2("m2")%></a><br>
<%
r2.movenext
loop
%>
</span>
<%
r2.close
r1.movenext
i = i + 1
loop
%>