欧洲冠军杯 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%>
<%=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")%> |
<%
drs.movenext
wend
drs.close%>
|
欧洲冠军杯 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%>
<%=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")%> |
<%
drs.movenext
wend
drs.close%>
|
|