|
|
| |
 |
| |
|
SPORTS 18 - T20 CORPORATE CRICKET
TOURNAMENT |
|
|
|
|
<%
DIM mySQL, objRS, sl, Active
Active = "1"
mySQL = "SELECT * FROM Matches Where Tournament_Id=3 AND MatchActive=1 "
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL, db
%>
<%
While Not objRS.EOF %>
|
<%= objrs("MatchGroup")%> |
|
|
| Date: <%= objrs("MatchDate")%> <%= objrs("MatchDay")%> |
Ground: <%= objrs("Ground")%> |
| Time: <%= objrs("MatchTime")%> |
|
|
<%
DIM mySQL1, objRS1
mySQL1 = "SELECT * FROM CompanyRegister Where Id=" &objRs("Team1")
Set objRS1 = Server.CreateObject("ADODB.Recordset")
objRS1.Open mySQL1, db
%>
<%
DIM mySQL2, objRS2
mySQL2 = "SELECT * FROM CompanyRegister Where Id=" &objRs("Team2")
Set objRS2 = Server.CreateObject("ADODB.Recordset")
objRS2.Open mySQL2, db
%>
 "> |
v/s |
 "> |
|
<%= objRs1("CompanyName") %> |
|
<%= objRs2("CompanyName") %> |
|
|
|
<%
objRs.MoveNext
wend
%>
|
|
|
|
|
|
|
|
|
