国际足联最新排名

地区：所有地区<% area="欧洲" if len(request("area"))>0 then area=strgl(request("area")) set rs=conn.execute("select distinct city from football_team where name=country and city is not null") while not rs.eof %>"&rs(0)&"" rs.movenext wend%> 国家：所有球队<% team="" if len(request("team"))>0 then team=strgl(request("team")) set rs=conn.execute("select name from football_team where name=country and city='"&area&"' order by name") while not rs.eof %>"&rs(0)&"" rs.movenext wend%> 时间：请选择<% intime="" set trs=conn.execute("select max(intime) from football_fifarank") if not trs.eof then intime=trs(0) if len(request("intime"))>0 then intime=strgl(request("intime")) set rs=conn.execute("select distinct intime from football_fifarank order by intime desc") while not rs.eof %>"&year(rs(0))&"年"&month(rs(0))&"月"&"" rs.movenext wend%>

<% if team<>"" then set rs=conn.execute("select * from football_fifarank where team='"&team&"' order by intime desc") elseif area<>"" and intime<>"" then set rs=conn.execute("select a.* from football_fifarank a inner join football_team b on a.team=b.name where b.city='"&area&"' and a.intime='"&intime&"' order by a.paiming") elseif intime<>"" then set rs=conn.execute("select * from football_fifarank where intime='"&intime&"' order by paiming") else set rs=conn.execute("select top 100 * from football_fifarank order by intime desc,paiming") end if i=1 while not rs.eof%> align=center height=18> 时间 FIFA排名 区域排名 总 积 分 球队名称 FIFA上月排名 升降 <%=(year(rs("intime"))&"年"&month(rs("intime"))&"月")%> <%=rs("paiming")%> <%=rs("paiming_area")%> <%=rs("jifen")%> <%if instr(rs("team"),"中国")>0 then response.write ""%><%=rs("team")%> <%=rs("paiming_old")%> <% temp=rs("paiming_old")-rs("paiming") if temp>0 then response.write "↑"&temp elseif temp<>0 then response.write "↓"&abs(temp) end if rs.movenext wend%>