<%@LANGUAGE="VBSCRIPT"%> <% Dim u11bFixtures__MMColParam u11bFixtures__MMColParam = "1" If (Request.QueryString("U-11 B") <> "") Then u11bFixtures__MMColParam = Request.QueryString("U-11 B") End If %> <% Dim u11bFixtures Dim u11bFixtures_numRows Set u11bFixtures = Server.CreateObject("ADODB.Recordset") u11bFixtures.ActiveConnection = MM_WSFLwebsite_STRING u11bFixtures.Source = "SELECT * FROM qryFixtures WHERE League = '" + Replace(u11bFixtures__MMColParam, "'", "''") + "'" u11bFixtures.CursorType = 0 u11bFixtures.CursorLocation = 2 u11bFixtures.LockType = 1 u11bFixtures.Open() u11bFixtures_numRows = 0 %> <% Dim u11bResults__MMColParam u11bResults__MMColParam = "U-11 B" If (Request("MM_EmptyValue") <> "") Then u11bResults__MMColParam = Request("MM_EmptyValue") End If %> <% Dim u11bResults Dim u11bResults_numRows Set u11bResults = Server.CreateObject("ADODB.Recordset") u11bResults.ActiveConnection = MM_WSFLwebsite_STRING u11bResults.Source = "SELECT * FROM qryResults WHERE League = '" + Replace(u11bResults__MMColParam, "'", "''") + "'" u11bResults.CursorType = 0 u11bResults.CursorLocation = 2 u11bResults.LockType = 1 u11bResults.Open() u11bResults_numRows = 0 %> <% Dim u11bTable__MMColParam u11bTable__MMColParam = "U-11 B" If (Request("MM_EmptyValue") <> "") Then u11bTable__MMColParam = Request("MM_EmptyValue") End If %> <% Dim u11bTable Dim u11bTable_numRows Set u11bTable = Server.CreateObject("ADODB.Recordset") u11bTable.ActiveConnection = MM_WSFLwebsite_STRING u11bTable.Source = "SELECT * FROM qrysub_LEAGUE WHERE League = '" + Replace(u11bTable__MMColParam, "'", "''") + "'" u11bTable.CursorType = 0 u11bTable.CursorLocation = 2 u11bTable.LockType = 1 u11bTable.Open() u11bTable_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 u11bFixtures_numRows = u11bFixtures_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 u11bResults_numRows = u11bResults_numRows + Repeat2__numRows %> <% Dim Repeat3__numRows Dim Repeat3__index Repeat3__numRows = -1 Repeat3__index = 0 u11bTable_numRows = u11bTable_numRows + Repeat3__numRows %> Waterford Schoolboys Football League
Main Menu
Submenu

 Latest News
 Fixtures
 Results
 Tables
 Picture Gallery

 History
 Committee
 Clubs
 Development Squads

 Famous Players
 Links

 

Waterford Schoolboys Football League

Under 11 B League

Table

<% While ((Repeat3__numRows <> 0) AND (NOT u11bTable.EOF)) %> <% Repeat3__index=Repeat3__index+1 Repeat3__numRows=Repeat3__numRows-1 u11bTable.MoveNext() Wend %>
Pld
W
D
L
F
A
GD
Pts
<%=(u11bTable.Fields.Item("Home Team").Value)%>
<%=(u11bTable.Fields.Item("Pld").Value)%>
<%=(u11bTable.Fields.Item("W").Value)%>
<%=(u11bTable.Fields.Item("D").Value)%>
<%=(u11bTable.Fields.Item("L").Value)%>
<%=(u11bTable.Fields.Item("F").Value)%>
<%=(u11bTable.Fields.Item("A").Value)%>
<%=(u11bTable.Fields.Item("GD").Value)%>
<%=(u11bTable.Fields.Item("Pts").Value)%>

 

Pld:
W:
D:
L:
F:
A:
GD:
Pts:
Games Played
Games Won
Games Drawn
Games Lost
Goals For/Scored
Goals Against / Conceeded
Goal Difference
Points

 

Results

<% While ((Repeat2__numRows <> 0) AND (NOT u11bResults.EOF)) %> <% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 u11bResults.MoveNext() Wend %>
<%=(u11bResults.Fields.Item("Home Team").Value)%>
<%=(u11bResults.Fields.Item("HomeScore").Value)%>
-
<%=(u11bResults.Fields.Item("AwayScore").Value)%> <%=(u11bResults.Fields.Item("Away Team").Value)%>

 

 

Fixtures

<% While ((Repeat1__numRows <> 0) AND (NOT u11bFixtures.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 u11bFixtures.MoveNext() Wend %>
Date
Venue
Fixtures
Referee
<%=(u11bFixtures.Fields.Item("Date").Value)%>
<%=(u11bFixtures.Fields.Item("Venue").Value)%>
<%=(u11bFixtures.Fields.Item("Home Team").Value)%>
v
<%=(u11bFixtures.Fields.Item("Away Team").Value)%>
<%=(u11bFixtures.Fields.Item("Referee").Value)%>

 

 Under 11
   A   B   C   D

 Under 12
   A   B   C

 Under 13
   A   B   C

 Under 14
   A   B

 Under 15
   A   B

 Under 16
   A   B   C

  
  
© Waterford Schoolboys Football League 2004. Administration >>
<% u11bFixtures.Close() Set u11bFixtures = Nothing %> <% u11bResults.Close() Set u11bResults = Nothing %> <% u11bTable.Close() Set u11bTable = Nothing %>