<% d1=#2012-3-30# d2=#2012-3-29# Set dRs=Conn.Execute("Select id,playtime,mainteam,subteam,jinqiu,shiqiu,lb from football_play 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"))%>	<%Set uRs=Conn.Execute("Select name from football_team where id='"&drs("mainteam")&"'") if urs("name")=""then response.write else response.write replace(urs("name"),"队","") end if response.write " VS " Set uRs=Conn.Execute("Select name from football_team where id='"&drs("subteam")&"'") if urs("name")=""then response.write else response.write replace(urs("name"),"队","") end if set urs=nothing %>	<%=drs("jinqiu")%>-<%=drs("shiqiu")%>

<% d1=#2012-4-7# d2=#2012-4-5# Set dRs=Conn.Execute("Select id,playtime,mainteam,subteam,jinqiu,shiqiu,lb from football_play 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"))%>	<%Set uRs=Conn.Execute("Select name from football_team where id='"&drs("mainteam")&"'") if urs("name")=""then response.write else response.write replace(urs("name"),"队","") end if response.write " VS " Set uRs=Conn.Execute("Select name from football_team where id='"&drs("subteam")&"'") if urs("name")=""then response.write else response.write replace(urs("name"),"队","") end if set urs=nothing %>	<%=drs("jinqiu")%>-<%=drs("shiqiu")%>