hotmerchandise.asp

21世纪人才www.51zy.net 网站源码

<div id="hotmerchandise">
			<h1><span class="hide">热卖排行</span></h1>
			<!-- 热卖排行查询数据库开始 -->
			<%set rs=server.CreateObject("adodb.recordset")
			rs.open "select top 10 bookid,bookname,liulancount from shop_books order by liulancount desc",conn,1,1%><ol>
			<%i=0
			do while not rs.eof%>	<li><%response.write "<a href=""list.asp?id="&rs("bookid")&""" title=""此商品已被浏览过"&rs("liulancount")&"次"">"
			if len(trim(rs("bookname")))>10 then
			response.write left(trim(rs("bookname")),9)&".."
			else
			response.write trim(rs("bookname"))
			end if
			response.write "</a>"%></li>
			<%i=i+1
			if i>=10 then exit do
			rs.movenext
			loop
			%></ol>
			<!-- 热卖排行查询数据库结束 -->
		</div>