recopro.asp

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

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select top 10 bookid,bookname,chengjiaocount from wq_books where bestbook=1 order by chengjiaocount desc",conn,1,1%>
<tr>
    <td height="33"><img src="image/tjpro.gif" width="178" height="33"></td>
</tr>
<tr> 
<td> 
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr> 
</tr>
<%i=0
do while not rs.eof%>
<tr> 
          <td height="24" background="image/dp_bg.gif" >　 
            <%response.write "<a href=list.asp?id="&rs("bookid")&"  title=此商品已成功销售"&rs("chengjiaocount")&"次>"
				if len(trim(rs("bookname")))>15 then
				response.write left(trim(rs("bookname")),13)&".."
				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%>
<tr> 
<td height="1" ></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="10">
<tr>
</tr>
</table>
</td>
</tr>
</table>