sort_left.asp

来自「《网上图书订购系统》 1.后台数据库：SQL Server 2000 2.在」· ASP 代码 · 共 37 行

<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
}
-->
</style>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td width="193" height="42" bgcolor="#55BFFF"><img src="images/bookopen.gif"> 图书分类</td>
  </tr>
  <tr>
    <td valign="top" bgcolor="#FFFFFF">
	   <table width="100%" border="0" cellpadding="4" cellspacing="2">
	  <%
	  set rs=server.CreateObject("adodb.recordset")
	  strsql="select * from tb_bookkinds"
	  rs.open strsql,conn,3,3
	  i=1
	  do while not rs.eof
	  %>
	     <tr>
	       <td width="5%" valign="bottom" bgcolor="#F5F5F5">
             <div align="right"><img src="images/1.bmp"></div></td>
		   <td width="95%" bgcolor="#F5F5F5"><a href="booklist.asp?Type=<%=rs(0)%>"><%=rs(0)%></a></td>
	     </tr>
	   <%
	   i=i+1
	   rs.movenext
	   loop
	   rs.close
	   %> 
    </table>   </td>
  </tr>
</table>