<div class="botton">
<%
set rsbig = server.CreateObject("adodb.recordset")
rsbig.open "select * from BigClass",conn,1,1
if not(rsbig.bof and rsbig.eof) then
set rssmall = server.CreateObject("adodb.recordset")
do while not rsbig.eof
i=0

%>-----大类循环出来~成功~~~~

<a href="product.asp?BigClassID=<%=rsbig("BigClassID")%>" onClick="return clickreturnvalue()" onMouseover="dropdownmenu(this, event, 'anylinkmenu<%=i%>')"><%=rsbig("BigClassName")%></a>

<div id="anylinkmenu<%=i%>" class="anylinkcss" style="width: 100px; background-color: lightyellow">

<%
rssmall.open "select * from SmallClass where BigClassID="&rsbig("BigClassID"),conn,1,1

response.Write("select * from SmallClass where BigClassID="&rsbig("BigClassID"))

if not(rssmall.bof and rssmall.eof) then
do while not rssmall.eof
b=0

%>----循环对应的小类~~~失败

<a href="product.asp?BigClassID=<%=rsbig("BigClassID")%>&SmallClassID=<%=rssmall("SmallClassID")%>"><%=rssmall("SmallClassName")%></a>

<%
rssmall.movenext
loop
b=b+1
end if

%>
</div>

<%
rsbig.movenext
loop
i=i+1
end if
%>
</div>



能帮我修改一下代码吗???相对应的小类不出来哦~~~~~~
只能出来数据库的第一个大类的小类~~~~