<%@ Language=VBScript %> <% Option Explicit %> <% Response.Expires = 0 %> <% Dim oCs, oRs, strSQL set oCs = server.createobject("ADODB.Connection") oCs.Open "Driver={Microsoft Excel Driver (*.xls)}; DBQ=" & Server.MapPath("/season/01-02/data") & "/stats01-02.xls;" strSQL = "SELECT * FROM [Apps$] WHERE Player <> '0' ORDER BY Num ;" Set oRs = oCs.Execute(strSQL) %> ToffeeWeb - Everton Player Appearances, 2001-02
Search User

Player Appearances, 2001-02

Definitive Stats of Everton Appearances, Goals and Cards received in 
League and Cup games during the 2001-02 Season
  Appearances, 2000-01 Appearances, 2002-03
APPEARANCES, GOALS & CARDS  

<%Do while NOT oRs.EOF%> <%oRs.MoveNext%><%Loop%>
No Player Appearances Goals Cards
    Prem Cup Total Prem Cup Total Yellow Red
 <%=oRs("Num")%>   <%=oRs("Player")%> <%=oRs("PlayedLeague")%>(<%=oRs("SubLeague")%>) <%=oRs("PlayedCup")%>(<%=oRs("SubCup")%>) <%=oRs("PlayedTotal")%>(<%=oRs("SubTotal")%>) <%=oRs("ScoredLeague")%>  <%=oRs("ScoredCup")%>  <%=oRs("ScoredTotal")%>  <%=oRs("Yellow")%>  <%=oRs("AllRed")%> 



Figures in brackets indicate substitute appearances
Yellow cards exclude double-yellows
Red cards include double-yellow dismissals
Greyed-out players are no longer with the club
Excludes loan spells away from Everton

<% oCs.Close Set oRs = Nothing %>