selltop.asp
上传用户:btntkt
上传日期:2021-04-16
资源大小:5296k
文件大小:2k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

DOS

  1. <%set rs=server.CreateObject("adodb.recordset")
  2.   rs.open "select top 10 * from products  where zhuangtai=0 order by chengjiaocount desc",conn,1,1%>
  3. <style type="text/css">
  4. <!--
  5. .style4 {color: #FF5C99}
  6. -->
  7. </style>
  8. <table width="190" border="0" cellspacing="0" cellpadding="0">
  9.   <tr>
  10.     <td><div align="center"><img src="images/body/left01.gif" width="183" height="43" /></div></td>
  11.   </tr>
  12.   <tr>
  13.     <td>
  14.       <table  width="100%" border="0" cellpadding="0" cellspacing="0">
  15.         <%i=0
  16. do while not rs.eof%>
  17.         <tr>
  18.           <td width="1%" height="24" valign="middle"></td>
  19.           <td width="99%" valign="middle">&nbsp;<img src="images/body/dian2.gif" width="14" height="15" />
  20.             <%response.write "<a href=products.asp?id="&rs("bookid")&"  title=此商品已成功销售"&rs("chengjiaocount")&"次>"
  21. if len(trim(rs("bookname")))>8then
  22. response.write left(trim(rs("bookname")),8)&".."
  23. else
  24. response.write trim(rs("bookname"))
  25. end if
  26. response.write "</a>"
  27. %>
  28.             <font color="#DC143C"><font color="#DC143C">¥<%=trim(rs("huiyuanjia"))%></font></font>
  29.             <table width="100%" height="1"  border="0" cellpadding="0" cellspacing="0" background="image/lineDotGray.gif">
  30.               <tr>
  31.                 <td height="1" background="images/blank.gif"></td>
  32.               </tr>
  33.           </table></td>
  34.         </tr>
  35.         <%i=i+1
  36.   if i>=10 then exit do
  37.   rs.movenext
  38.   loop
  39.   rs.close
  40.   set rs=nothing%>
  41.       </table></td>
  42.   </tr>
  43. </table>