欧罗巴联赛第二轮第一回合 |
<%
d1=#2011-7-18#
d2=#2011-7-13#
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 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")%> |
<%drs.movenext
wend
drs.close
%>
|
欧罗巴联赛第二轮第二回合 |
<%
d1=#2011-7-25#
d2=#2011-7-20#
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 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")%> |
<%drs.movenext
wend
drs.close
%>
|
|