hotinfo.asp

电子商务购物系统

 
<table width="100%" class="table-shangxia" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td height="23" bgcolor="f1f1f1">　<a href="bookorder.asp">热点商品</a></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <%set rs=server.CreateObject("adodb.recordset")
		  rs.open "select top 10 bookid,bookname,liulancount from shop_books order by liulancount desc",conn,1,1%>
  <tr> 
    <td> 
      <table width="88%" border="0" cellpadding="0" cellspacing="0" align="center" height="63">
        <tr> 
          <td height="2"></td>
        </tr>
        <tr> 
          <td height="20"> 
            <div align="center"> </div>
          </td>
        </tr>
        <%i=0
			  do while not rs.eof%>
        <tr> 
          <td height="23" class="table-xia"> 
            <%response.write "<a href=book.asp?id="&rs("bookid")&" target=_blank 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>
    </td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
</table>