<% d1=#2011-8-02# d2=#2011-7-25# Set drs=Conn.Execute("Select a.id,a.status,a.mainteam,a.subteam,a.jinqiu,a.shiqiu,a.playtime,b.name as mname,c.name as sname from football_play a inner join football_team b on a.mainteam=b.id inner join football_team c on a.subteam=c.id where lb='欧罗巴联赛' and playtime<'"&d1&"' and playtime>'"&d2&"' order by playtime") %> <%while not drs.eof%> <%drs.movenext wend drs.close %>

比赛时间	对阵	比分
<%=year(drs("playtime"))%>.<%=month(drs("playtime"))%>.<%=day(drs("playtime"))%>　<%=hour(drs("playtime"))%>:<%=minute(drs("playtime"))%>	<% if drs("mname")=""then response.write else response.write replace(drs("mname"),"队","") end if response.write " VS " if drs("sname")=""then response.write else response.write replace(drs("sname"),"队","") end if %>	<%=drs("jinqiu")%>-<%=drs("shiqiu")%>

<% d1=#2011-8-08# d2=#2011-8-03# Set drs=Conn.Execute("Select a.id,a.status,a.mainteam,a.subteam,a.jinqiu,a.shiqiu,a.playtime,b.name as mname,c.name as sname from football_play a inner join football_team b on a.mainteam=b.id inner join football_team c on a.subteam=c.id where lb='欧罗巴联赛' and playtime<'"&d1&"' and playtime>'"&d2&"' order by playtime") %> <%while not drs.eof%> <%drs.movenext wend drs.close %>

比赛时间	对阵	比分
<%=year(drs("playtime"))%>.<%=month(drs("playtime"))%>.<%=day(drs("playtime"))%>　<%=hour(drs("playtime"))%>:<%=minute(drs("playtime"))%>	<% if drs("mname")=""then response.write else response.write replace(drs("mname"),"队","") end if response.write " VS " if drs("sname")=""then response.write else response.write replace(drs("sname"),"队","") end if %>	<%=drs("jinqiu")%>-<%=drs("shiqiu")%>