<%@ 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/03-04/data") & "/stats.xls;" strSQL = "SELECT * FROM [Apps$] WHERE AssistsTotal > 0 ORDER BY AssistsTotal DESC ;" Set oRs = oCs.Execute(strSQL) %> ToffeeWeb - Everton Goalmakers, 2003-04

Goalmakers, 2003-04

The players who created the goals for Everton (aka "assists")
  

 2002-03 Goalmakers 2004-05 Goalmakers 
EVERTON GOALMAKERS Correct to:

<%Do while NOT oRs.EOF%> <%oRs.MoveNext%><%Loop%>
No.  Player League FA Cup WLC Total

<%=oRs("Num")%>

 <%=oRs("Player")%> <%=oRs("AssistsLeague")%>  <%=oRs("AssistsFACup")%>  <%=oRs("AssistsWLCup")%>  <%=oRs("AssistsTotal")%> 
 
Who are the Goalmakers?

Goalmakers are defined variously as:-

The penultimate Everton player touching the ball in a move which leads to a goal;

The Everton player fouled in the course of winning a converted penalty;

The goalscorer himself where the goal results from a solo effort not involving any other Everton players.

Goals scored purely from a mistake or unforced error of an opposition player are not included.