sort.asp

购物系统时尚版.强大的后台文章编辑器的功能

 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td> 
      <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td height="6"></td>
        </tr>
        <tr> 
          <td height="20"> 
            <%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from big_class order by id",conn,1,1
if rs.recordcount=0 then
	response.write "<br>目前没有商品分类"
else
	while not rs.eof
%>
            <table width=100% cellspacing="0" cellpadding="0" border="0">
              <tr> 
                <td colspan=2 height="22">&nbsp;<img src=images/soimg.gif align=absmiddle><a href="big_class.asp?bid=<%=rs("id")%>"><%=rs("txt_big_class")%></a></td></td>
              </tr>
              <%
	    set rs_s=server.CreateObject("adodb.recordset")
	    rs_s.open "select * from small_class where iid=" & rs("id") & " order by id",conn,1,1
	    if rs_s.recordcount=0 then 
%>
              <tr> 
                <td colspan=2 height="22">&nbsp;&nbsp;<a href="#">暂无小分类</a></td>
              </tr>
              <%
	    else
	    	i=0
		while not rs_s.eof
%>
              <tr> 
                <td align=left width=49% height="22">&nbsp;&nbsp;<a href="small_class.asp?bid=<%=rs("id")%>&sid=<%=rs_s("id")%>"><%=rs_s("txt_small_class")%></a></td>
                <%rs_s.movenext
if rs_s.eof then 
response.write "<td align=center>&nbsp;</td></tr>"
else
%>
                <td align=left width=51% height="22"><a href="small_class.asp?bid=<%=rs("id")%>&sid=<%=rs_s("id")%>"><%=rs_s("txt_small_class")%></a></td>
              </tr>
              <%
rs_s.movenext
end if%>
              <%
		wend
	    end if
%>
              <tr> 
                <td colspan=2 height=1 ><hr size="1" color="#E8E8E8"></td>
              </tr>
            </table>
            <%
	    rs_s.close
	    set rs_s=nothing
	rs.movenext
	wend
end if
rs.close
set rs=nothing
%>
          </td>
        </tr>
        <tr> 
          <td></td>
        </tr>
        <tr> 
          <td height="1"></td>
        </tr>
        <tr> 
          <td height="1"></td>
        </tr>
      </table>
    </td>
  </tr>
</table>