|
欧罗巴联赛第三轮第一回合 |
<%
d1=#2011-8-02#
d2=#2011-7-25#
Set drs=Conn.Execute("Select a.id,a.status,a.mainteam,a.subteam,a.jinqiu,a.shiqiu,a.playtime,b.name as mname,c.name as sname 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%>
| <%=year(drs("playtime"))%>.<%=month(drs("playtime"))%>.<%=day(drs("playtime"))%> <%=hour(drs("playtime"))%>:<%=minute(drs("playtime"))%> |
<%
if drs("mname")=""then
response.write
else
response.write replace(drs("mname"),"队","")
end if
response.write " VS "
if drs("sname")=""then
response.write
else
response.write replace(drs("sname"),"队","")
end if
%>
|
<%=drs("jinqiu")%>-<%=drs("shiqiu")%> |
<%drs.movenext
wend
drs.close
%>
|
|
欧罗巴联赛第三轮第二回合 |
<%
d1=#2011-8-08#
d2=#2011-8-03#
Set drs=Conn.Execute("Select a.id,a.status,a.mainteam,a.subteam,a.jinqiu,a.shiqiu,a.playtime,b.name as mname,c.name as sname 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%>
| <%=year(drs("playtime"))%>.<%=month(drs("playtime"))%>.<%=day(drs("playtime"))%> <%=hour(drs("playtime"))%>:<%=minute(drs("playtime"))%> |
<%
if drs("mname")=""then
response.write
else
response.write replace(drs("mname"),"队","")
end if
response.write " VS "
if drs("sname")=""then
response.write
else
response.write replace(drs("sname"),"队","")
end if
%>
|
<%=drs("jinqiu")%>-<%=drs("shiqiu")%> |
<%drs.movenext
wend
drs.close
%>
|
|