<select name="jinji">
<option value="请选择" selected>请选择</option>
<%
//连接数据库
set rs1=server.createobject("adodb.recordset")
sql1="select * from tsec_grade"
rs1.open sql1,conn,1
while not rs1.eof and not rs1.bof
%>
<option value="<%=rs1("id")%>"><%=rs1("fsec_grade")%></option>
<%
rs1.movenext
wend
%>
</select>
mm_menu_0807114755_0.addMenuItem("西洋乐器","location='cpxx.asp?kind=西洋乐器'");
mm_menu_0807114755_0.addMenuItem("电声乐器","location='cpxx.asp?kind=电声乐器'");
mm_menu_0807114755_0.addMenuItem("打击乐器","location='cpxx.asp?kind=打击乐器'");
mm_menu_0807114755_0.addMenuItem("民族乐器","location='cpxx.asp?kind=民族乐器'");
mm_menu_0807114755_0.addMenuItem("舞台灯光音响","location='cpxx.asp?kind=舞台灯光音响'");
mm_menu_0807114755_0.addMenuItem("戏剧服装","location='cpxx.asp?kind=戏剧服装'");
替换成:
<%
dim rsCata
//rsCata获得菜单的recordSet,这里省略
if not rsCata.eof then
%>
mm_menu_0807114755_0.addMenuItem("<%=rsCata("xuanxiang")%>","location='cpxx.asp?kind=("<%=rsCata("xuanxiang")%>'");