<% set rs=server.CreateObject("adodb.recordset") rs.open "select top 10 id,name,solded from product order by solded 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 end if 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 "" %>
更多排行>>>