<%set rs=server.CreateObject("adodb.recordset")
rs.open "select top 12 bookid,bookname,liulancount from shop_books where info=0 order by liulancount desc",conn,1,1%>

<head>
<style type="text/css">
<!--
.unnamed1 {
	border-bottom-width: thin;
	border-bottom-style: dotted;
	border-bottom-color: #666666;
}
-->
</style>
</head>

<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" >
  <tr> 
    <td height="41" valign="top"> 
      <table width="100%" border="0" align="center" cellspacing="0" cellpadding="0">
        <%i=0
do while not rs.eof%>
        <tr> 
          <td height="22"> &nbsp;<img src="images/ring01.gif" width="3" height="5">
            <%response.write "<a href=list.asp?id="&rs("bookid")&" target=_blank title=此商品已被浏览过"&rs("liulancount")&"次>"  
				if len(trim(rs("bookname")))>9 then
				response.write left(trim(rs("bookname")),9)
				else
				response.write trim(rs("bookname"))
				end if
				response.write "</a>"
				%>
          </td>
        </tr>
        <tr><td background="imagess/please_dot_1.gif"></td></tr>
        <%i=i+1
			  if i>=12 then exit do
			  rs.movenext
			  loop
			  rs.close
			  set rs=nothing%>
        <tr> 
          <td height="11"  bordercolor="#FFFFFF" > 
          </td>
        </tr>
      </table>
      <%set rs=server.CreateObject("adodb.recordset")
	  rs.open "select top 12 * from shop_books where info=0 order by chengjiaocount desc",conn,1,1%>
    </td>
  </tr>
</table>
