renqirank.asp

漂亮公司企业网站自助建站系统 .asp.rar

<%set rs=server.CreateObject("adodb.recordset")
	  rs.open "select top 10 * from wq_books order by liulancount desc",conn,1,1%>
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><img src="image/rmsp.gif" width="178" height="34"></td>
  </tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<%i=0
do while not rs.eof%>
<tr>
    <td height="24" background="image/dp_bg.gif" class="table-you"  STYLE='PADDING-LEFT: 18px'> 
      <%response.write "<a href=list.asp?id="&rs("bookid")&"  title=此商品已被浏览了"&rs("liulancount")&"次>"
				if len(trim(rs("bookname")))>12 then
				response.write left(trim(rs("bookname")),11)&".."
				else
				response.write trim(rs("bookname"))
				end if
				response.write "</a>"
				%>
    </td>
</tr>
<%i=i+1
			  if i>=10 then exit do
			  rs.movenext
			  loop
			  rs.close
			  set rs=nothing%>
</table>