<% set rs=server.CreateObject("adodb.recordset") rs.open "select top 10 id,name,viewnum from product where categoryid="&catid&" order by viewnum desc",conn,1,1 if rs.eof and rs.bof then response.write "" else i=0 do while not rs.eof %> <% i=i+1 if i>=10 then exit do rs.movenext loop rs.close set rs=nothing end if%>
<% = strcat %>分类关注排行
暂无此类商品
<% response.write " ·" if len(trim(rs("name")))>20 then response.write left(trim(rs("name")),18)&"..." else response.write trim(rs("name")) end if response.write "
" %>