´ÓÊý¾Ý¿âÖжÁÈ¡Êý¾Ý£¬Ôõô¾Í½øÈëÁËËÀÑ­»·ÄØ

ÃÎaiqåÐÒ£

ÏÖÓбí1ºÍ±í2£¬±íÖдæ·ÅµÄÊÇ´óÀàµÄÃû×Ö£¬±í2Öдæ·ÅµÄÊÇ´óÀ༰ÏàÓ¦µÄСÀàµÄÃû×Ö£¬Òª¸ù¾Ý±í1µÄ´óÀàµÄÃû×Ö´Ó±í2ÖжÁÈ¡ÏàÓ¦µÄСÀàµÄÃû×Ö£¬¿É×ÜÊǽøÈëËÀÑ­»·£¬´úÂëÈçÏ£º
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
set rs_qiyebc=server.createobject("adodb.recordset")
sqlqiyebc="select * from BigClass_down"
rs_qiyebc.open sqlqiyebc,conn,1,1
bcx=4
%>
<%do while not rs_qiyebc.eof%>
<tr>
<td><%=cutstr(rs_qiyebc("BigClassName"),11)%></td>
</tr>
<%
BigClassName=rs_qiyebc("BigClassName")
rs_qiyebc.movenext
if x=4 then exit do
loop
%>
<%
set rs_qiye3=server.createobject("adodb.recordset")
sqlqiye3="select * from SmallClass_down where BigClassName=" & BigClassName & ""
rs_qiye3.open sqlqiye3,conn,1,1
x3=0
%>
<%do while not rs_qiye3.eof%>
<tr>
<td><%=cutstr(rs_qiye3("SmallClassName"),11)%></td>
</tr>
<%
rs_qiye3.movenext
x3=x3+1
if x3=4 then exit do
loop
%>
</table>
ÇëÎÊÄÇÀïÓÐ´í°¡