<% d1=#2012-6-18# d2=#2012-6-8# Set dRs=Conn.Execute("Select a.id,a.status,a.mainteam,a.subteam,a.xmlpath,a.jinqiu,a.shiqiu,a.playtime,b.name as mname,b.yueyuname as tramname,c.name as sname,c.yueyuname as trasname 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%> <% if drs("mname")="波兰" or drs("mname")="希腊" or drs("mname")="俄罗斯" or drs("mname")="捷克" then %> <% end if drs.movenext wend drs.close %> <% d1=#2012-6-19# d2=#2012-6-9# Set dRs=Conn.Execute("Select a.id,a.status,a.mainteam,a.subteam,a.xmlpath,a.jinqiu,a.shiqiu,a.playtime,b.name as mname,b.yueyuname as tramname,c.name as sname,c.yueyuname as trasname 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%> <% if drs("mname")="荷兰" or drs("mname")="丹麦" or drs("mname")="德国" or drs("mname")="葡萄牙" then %> <% end if drs.movenext wend drs.close %> <% d1=#2012-6-20# d2=#2012-6-10# Set dRs=Conn.Execute("Select a.id,a.status,a.mainteam,a.subteam,a.xmlpath,a.jinqiu,a.shiqiu,a.playtime,b.name as mname,b.yueyuname as tramname,c.name as sname,c.yueyuname as trasname 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%> <% if drs("mname")="西班牙" or drs("mname")="意大利" or drs("mname")="爱尔兰" or drs("mname")="克罗地亚" then %> <% end if drs.movenext wend drs.close %> <% d1=#2012-6-21# d2=#2012-6-11# Set dRs=Conn.Execute("Select a.id,a.status,a.mainteam,a.subteam,a.xmlpath,a.jinqiu,a.shiqiu,a.playtime,b.name as mname,b.yueyuname as tramname,c.name as sname,c.yueyuname as trasname 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%> <% if drs("mname")="法国" or drs("mname")="英格兰" or drs("mname")="乌克兰" or drs("mname")="瑞典" then %> <% end if drs.movenext wend drs.close %>