|
|
<%
sql="select distinct BigClassName from (select BigClassName from PrSmallClass order by SmallClassID)"
sql="select * from PrBigClasss"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
i=0
do while not rs.eof
i=i+1
%>
height=17 src="images/class1.gif" width=15> |
"><%=rs("BigClassName")%> |
<%
set rs1=server.createobject("adodb.recordset")
sql1="select * from PrSmallClass where BigClassName=" & rs("BigClassName") & ""
rs1.open sql1,conn,1,3
do while not rs1.eof
%>
&Smallclassname=<%=rs1("SmallClassName")%>"><%=rs1("SmallClassName")%>
<%
rs1.movenext
loop
rs1.close
set rs1=nothing
%>
|
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
| |
|
|
|
|
| |
|
| |