半决赛对阵 第一回合 |
<%
d1=#2011-4-30#
d2=#2011-4-25#
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%>
|
半决赛对阵 第二回合 |
<%
d1=#2011-5-7#
d2=#2011-5-2#
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%>
|
|