<table style="border:1px solid #E0E0E0" width="100%" border="0" cellpadding="0" cellspacing="5" bgcolor="#F5F5F5">
<tr>
<td height="25" align="center" bgcolor="#FFFFFF"><font style="font-size:14px;color:#B21C00"><b>热点商品</b></font></td>
</tr>
<%set rs=server.createobject("adodb.recordset")
rs.open"select top 3 * from price_shjia where shjiaid="&request("id")&" order by count desc",conn,1,1
i=0
do while not rs.eof
money=split(rs("money"),"|")%>
<tr>
<td align="center" valign="top" bgcolor="#FFFFFF" style="padding:5px;border:1px solid #E0E0E0"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td align="center"><a href="price.asp?id=<%=rs_shjia("shjiaid")%>&book_id=<%=rs("book_id")%>"><img src="../<%=rs("pic")%>" width="120" height="80" border="1" style="border-color:#666666"></a></td>
</tr>
<tr>
<td height="3"></td>
</tr>
<tr>
<td align="center" style="padding-left:5px"><a href="price.asp?id=<%=rs_shjia("shjiaid")%>&bookid=<%=rs("bookid")%>"><font color="#666666"><b><%=left(rs("bookname"),8)%></b></font></a></td>
</tr>
<tr>
<td align="center" bgcolor="#C1C1C1" style="padding-left:5px">报价：<%=money(0)%>元</td>
</tr>
<tr>
<td align="center" bgcolor="#EEEEEE" style="padding-left:5px"><a href="../uindex/index.asp?action=goumai&id=<%=rs("bookid")%>&from=<%=rs_shjia("name")%>"><font color="#666666">购买产品</font></a>&nbsp;<a href="../shoucang.asp?id=<%=rs("bookid")%>&action=add" title="收藏"><font color="#666666">加入收藏</font></a></td>
</tr>
</table></td>
</tr>
<%rs.movenext
i=i+1
if i>=3 then exit do
loop
rs.close
set rs=nothing%>
</table>
