首页 > 互联资讯 > 技术交流 >

如何编写TOP 10之类的排行榜？

技术交流
2024-10-01 10:27:02

<% @ LANGUAGE="VBscript" %>

<% OPTION EXPLICIT %>

<% dim rs,sql,IDa,IDb,s,RegUser,a,b,c

Set rs=Server.CreateObject("ADODB.recordset")

sql="Select * from UserInfo ORDER BY iPerience DESC"

rs.Open sql,ConnStr,1,1

RegUser=rs.RecordCount

IDa=1

IDb=2

</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">山水盈盈之论坛大英雄</SPAN><SPAN lang=EN-US>

<% if RegUser<10 then

a=RegUser/2

else

a=5

end if

for s=1 to a

<%rs.movenext%>

IDa=IDa+2

IDb=IDb+2

rs.movenext

<% if RegUser>20 then

for b=11 to 15 %>

<% rs.movenext%>

end if %>

<% if RegUser>20 then

for c=16 to 20 %>

<% rs.movenext%>

end if %>

名次	网名	帖数	名次	网名	帖数
color="#0000A0"><%=IDa%>	','Call','width=350,height=400,left=300,top=100,toolbar=no,status=no')"><%=rs("UserName")%>	<%=rs("iPerience")%>	color="#0000A0"><%=IDb%>	','Call','width=350,height=400,left=300,top=100,toolbar=no,status=no')"><%=rs("UserName")%>	<%=rs("iPerience")%>
','Call','width=350,height=400,left=300,top=100,toolbar=no,status=no')"><%=rs("UserName")%>	','Call','width=350,height=400,left=300,top=100,toolbar=no,status=no')"><%=rs("UserName")%>