现在有十个数据进行排行
1、2名前面显示1、2名的图片
3、4名前面显示3、4名的图片以此类退
求这样的代码
谢谢了

按照发帖数

<%
              Set rs=Server.CreateObject("ADODB.RecordSet")
              sql="select top 10 * from news order by hits desc"
              rs.open sql,conn,1,1
              i=0
              do while (not rs.eof) and (i < 10)
              if i=1 then
                response.write("<img src='icon/1.gif'/>"&rs("title")&"<br>")
                elseif i=2 then
                response.write("<img src='icon/2.gif'/>"&rs("title")&"<br>")
                elseif i=3 then
                 response.write("<img src='icon/3.gif'/>"&rs("title")&"<br>")
                 elseif i=4 then
                 response.write("<img src='icon/4.gif'/>"&rs("title")&"<br>")
                 elseif i=5 then
                 response.write("<img src='icon/5.gif'/>"&rs("title")&"<br>")
                  elseif i=6 then
                 response.write("<img src='icon/6.gif'/>"&rs("title")&"<br>")
                   elseif i=7 then
                 response.write("<img src='icon/7.gif'/>"&rs("title")&"<br>")
                   elseif i=8 then
                 response.write("<img src='icon/8.gif'/>"&rs("title")&"<br>")
                 elseif i=9 then
                 response.write("<img src='icon/9.gif'/>"&rs("title")&"<br>")
                  elseif i=10 then
                 response.write("<img src='icon/10.gif'/>"&rs("title")&"<br>")
              i=i+1
              rs.movenext
              end if
              loop
              %>

写成这样了 好象是个死循环

万一遇到10和11的hits数相同的话 就会被全部提取出来

改成i=1之后提示不允许操作~!

<%
              Set rs=Server.CreateObject("ADODB.RecordSet")
              sql="select top 10 * from news where sort=19 order by hits desc"
              rs.open sql,conn,1,1
              i=1
              do while (not rs.eof) and (i < 10)
              response.write("<img src='icon/"&i&".gif'/>&nbsp;<a href='../hy/"&rs("moban")&"/ViewInfo.asp?idd="&rs("id")&"&id="&rs("UserID")&"'>"&mid(rs("title"),1,15)&"</a>&nbsp;<font color=ff0000>点击："&rs("hits")&"次</font><br>")
              i=i+1
              rs.movenext
                          loop
              %>
写成这样 OK了