📄 sellsort.asp
字号:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/conn.asp" -->
<%
set rs_sort=Server.CreateObject("ADODB.RecordSet")
sql="SELECT top 10 BookID, BookName, bnumber FROM DB_SellSum ORDER BY bnumber DESC,bookname"
rs_sort.open sql,conn,1,3
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>销售排行榜</title>
<link href="style.css" rel="stylesheet">
</head>
<body leftmargin="0" topmargin="0">
<table width="535" height="317" border="0" cellpadding="-2" cellspacing="-2">
<tr>
<td width="535" height="194" align="center" valign="top" background="images/bg_listmain.jpg">
<table width="97%" border="0" cellspacing="-2" cellpadding="-2">
<tr>
<td height="18"> </td>
</tr>
<tr>
<td height="30"><img src="images/sellsort.gif" width="210" height="30"></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="center"> <table width="97%" height="118" border="0"
cellpadding="-2" cellspacing="-2">
<tr>
<td height="118" valign="top">
<table width="100%" border="1" bordercolor="#ffffff" bordercolordark="#ffffff"
bordercolorlight="#0066ff" cellpadding="-21" cellspacing="0">
<tr>
<td width="27" height="20">
<div align="center"><strong>排名</strong></div></td>
<td width="100" height="20">
<div align="center"><strong>书号</strong></div></td>
<td width="297" height="20">
<div align="center"><strong>书名</strong></div></td>
<td width="42"><div align="center"><strong>数量</strong></div></td>
<td width="25" height="20"> </td>
</tr>
<%flag=1
while not rs_sort.eof
%>
<tr>
<td align="right"><strong><% =flag %> </strong></td>
<td> <%=(rs_sort("BookID"))%></td>
<td><A HREF="detail.asp?BookID=<%=rs_sort("BookID") %>">
<%=rs_sort("BookName")%> </A></td>
<td align="center"><%=rs_sort("bnumber")%></td>
<td width="25"><div align="center">
<a href="buycar_add.asp?bookID=<%= rs_sort("bookID") %>" target="_blank">
<img src="images/add.gif"
alt="添加至购物车" width="18" height="18" border="0" align="middle"></a>
</div></td>
</tr>
<%
flag=flag+1
rs_sort.movenext
wend %>
</table>
</td>
</tr>
</table>
<div align="center"></div></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -