<%set rs=server.CreateObject("adodb.recordset") rs.open "select top 10 id,name,viewnum from product order by viewnum desc",conn,1,1 if rs.eof and rs.bof then response.write "" end if i=0 do while not rs.eof%> <%i=i+1 if i>=10 then exit do rs.movenext loop rs.close set rs=nothing %>

关注排行

数据库中无商品

<%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 "" %>

更多排行>>>