left_bottom.asp

C2C二手交易网SMRUC v2.0 全部实现了C2C电子商务功能。 特别适合高校、组织、社区实现自己的C2C电子商务。 C2C二手交易网SMRUC v2.0具有强大的用户自主发布和管理信息功能

<table cellpadding="0" cellspacing="0">
<%
	exec_left1="select * from bclass"
	set rs_b=server.createobject("adodb.recordset")
	rs_b.open exec_left1,conn,1,1
%>

  <tr> 
    <td width="15" height="20" background="images/top_left.jpg">&nbsp;</td>
    <td width="80" background="images/top_mid.jpg"><FONT COLOR="ffffff"><B>分 类 目 录</B></FONT></td>
    <td width="75" background="images/top_mid.jpg">&nbsp;</td>
    <td width="20" background="images/top_right.jpg">&nbsp;</td>
  </tr>
<%
	do while not rs_b.eof
	set rs_b_a=server.createobject("adodb.recordset")
	rs_b_a.open "select count(info_id) as ct from info where info_status='有效' and  info_bclass="&rs_b("bclass_id"),conn,1,1
%>
  <tr>
    <td height="25">&nbsp;</td>
    <td colspan="2"><a href="show_bclass.asp?id=<%=rs_b("bclass_id")%>">-- <b><%=rs_b("bclass_name")%></b>(<%=rs_b_a("ct")%>) --</a></td>
    <td>&nbsp;</td>
  </tr>
<%
	exec_left2="select * from sclass where sclass_parent="&rs_b("bclass_id")
	set rs_s=server.createobject("adodb.recordset")
	rs_s.open exec_left2,conn,1,1
	do while not rs_s.eof
	set rs_s_a1=server.createobject("adodb.recordset")
	set rs_s_a2=server.createobject("adodb.recordset")
	rs_s_a1.open "select count(info_id) as ct from info where info_status='有效' and  info_sclass="&rs_s("sclass_id"),conn,1,1
%>
  <tr>
    <td>&nbsp;</td>
    <td>
	&nbsp;&nbsp;<a href="show_sclass.asp?id=<%=rs_s("sclass_id")%>"><%=rs_s("sclass_name")%>(<%=rs_s_a1("ct")%>)</a>
	</td>
	<%
		rs_s.movenext
		if not rs_s.eof then
		rs_s_a2.open "select count(info_id) as ct from info where info_status='有效' and  info_sclass="&rs_s("sclass_id"),conn,1,1
	%>
	<td colspan="2">
	&nbsp;&nbsp;<a href="show_sclass.asp?id=<%=rs_s("sclass_id")%>"><%=rs_s("sclass_name")%>(<%=rs_s_a2("ct")%>)</a>
	</td>
	<%
			rs_s.movenext
		else
	%>
	<td colspan="2">&nbsp;</td>
	<%
		end if
	%>
  </tr>
<%
	loop
	rs_b.movenext
	loop
	rs_s.close
	rs_b.close
%>
</table>