HOME   ABOUT SPORTS18 TEAMS MATCHES CLIENTS EVENTS

Teams Competing in the SPORTS 18 - T20 CORPORATE CRICKET TOURNAMENT       <% DIM mySQL, objRS, sl, Active mySQL = "SELECT * FROM PoolDetails where TournamentId=3 AND PoolId=10" Set objRS = Server.CreateObject("ADODB.Recordset") objRS.Open mySQL, db %> <% While Not objRS.EOF %> <% objRs.MoveNext wend %> POOL A   <%= objrs("TeamName") %>     <% DIM mySQL1, objRS1 mySQL1 = "SELECT * FROM PoolDetails where TournamentId=3 AND PoolId=11" Set objRS1 = Server.CreateObject("ADODB.Recordset") objRS1.Open mySQL1, db %> <% While Not objRS1.EOF %> <% objRs1.MoveNext wend %> POOL B   <%= objrs1("TeamName") %>     <% DIM mySQL2, objRS2 mySQL2 = "SELECT * FROM PoolDetails where TournamentId=3 AND PoolId=12" Set objRS2 = Server.CreateObject("ADODB.Recordset") objRS2.Open mySQL2, db %> <% While Not objRS2.EOF %> <% objRs2.MoveNext wend %> POOL C   <%= objrs2("TeamName") %>     <% DIM mySQL3, objRS3 mySQL3 = "SELECT * FROM PoolDetails where TournamentId=3 AND PoolId=13" Set objRS3 = Server.CreateObject("ADODB.Recordset") objRS3.Open mySQL3, db %> <% While Not objRS3.EOF %> <% objRs3.MoveNext wend %> POOL D   <%= objrs3("TeamName") %>     <% DIM mySQL4, objRS4 mySQL4 = "SELECT * FROM PoolDetails where TournamentId=3 AND PoolId=14" Set objRS4 = Server.CreateObject("ADODB.Recordset") objRS4.Open mySQL4, db %> <% While Not objRS4.EOF %> <% objRs4.MoveNext wend %> POOL E   <%= objrs4("TeamName") %>     <% DIM mySQL5, objRS5 mySQL5 = "SELECT * FROM PoolDetails where TournamentId=3 AND PoolId=15" Set objRS5 = Server.CreateObject("ADODB.Recordset") objRS5.Open mySQL5, db %> <% While Not objRS5.EOF %> <% objRs5.MoveNext wend %> POOL F   <%= objrs5("TeamName") %>

Concept & Design: R & D Web Solutions

Corporate Cricket Tournaments  |  G Event Management Bangalore