<% Session("title")="2011-2012赛季欧洲冠军杯" %>

2011--2012赛季欧洲冠军杯
欧洲冠军杯 1/8 决赛 第一回合
<% d1=#2012-2-25# d2=#2012-2-12# 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 cpname from football_team where id='"&drs("mainteam")&"'") if urs("cpname")=""then response.write else response.write replace(urs("cpname"),"队","") end if response.write " VS " Set uRs=Conn.Execute("Select cpname from football_team where id='"&drs("subteam")&"'") if urs("cpname")=""then response.write else response.write replace(urs("cpname"),"队","") end if set urs=nothing %> <%=drs("jinqiu")%>-<%=drs("shiqiu")%>

欧洲冠军杯 1/8 决赛 第二回合
<% d1=#2012-3-18# d2=#2012-3-06# 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 cpname from football_team where id='"&drs("mainteam")&"'") if urs("cpname")=""then response.write else response.write replace(urs("cpname"),"队","") end if response.write " VS " Set uRs=Conn.Execute("Select cpname from football_team where id='"&drs("subteam")&"'") if urs("cpname")=""then response.write else response.write replace(urs("cpname"),"队","") end if set urs=nothing %> <%=drs("jinqiu")%>-<%=drs("shiqiu")%>
 

中国足彩网 Email:webmaster@zgzcw.com
打印设置    打印文章