<%
          set rs=server.CreateObject("adodb.recordset")
          rs.open "select shengname,proid from province order by shengorder",conn,1,1
          do while not rs.eof %>



                            <%response.write "<br>&nbsp;&nbsp;&nbsp;<b><font color=#FF3300>"&trim(rs("shengname"))&"</font></b>&nbsp;&nbsp;<br>"%>


<% set rs2=server.CreateObject("adodb.recordset")
            rs2.open "select shiname,ctid from city where proid="&rs("proid")&" order by shiorder",conn,1,1
            do while not rs2.eof
            response.write "&nbsp;&nbsp;&nbsp;<font color=#0099cc>"&trim(rs2("shiname"))&"</font>  "
             rs2.movenext
             loop
             rs2.close
             set rs2=nothing
             response.write "<br>"%>

            <% rs.movenext
            loop
                rs.close
                set rs=nothing%>




数据表
province
prodi shengname shengid shengorder

city
ctid shiname shiNO shiorder shengid

我有一个province city mengber
想要在省的下面显示市,点击市后显示属于该市的会员的内容,我应该如何实现?有什么更好的方法

没人帮忙?郁闷!!!是我弄得让人看不懂还是没人想帮忙???

嵌套循环即可

不知道怎么回事,网页一直处于打开状态好长时间,最后并没有显示出来

那说明可能是死循环