<% strTeamName = "Arsenal" set conn = Server.CreateObject("ADODB.Connection") strConnect = "DRIVER={MySQL ODBC 3.51};SERVER=mysql.kfccrush.com;PORT=3306;DATABASE=kfccrush; USER=kfccrush;PASSWORD=$occerdb;OPTION=3;" conn.open strConnect Set rstCoach = Server.CreateObject("ADODB.RecordSet") txtSQL = "SELECT Teams.AgeGrpID, TeamName, Coach, CoachEmail, WebpageURL, AgeGrpDesc " & _ "FROM Teams, LOV_AgeGroups " & _ "WHERE Teams.TeamName = '" & strTeamName & "' " & _ "AND Teams.AgeGrpID = LOV_AgeGroups.AgeGrpID" rstCoach.Open txtSQL, conn Set rstAsst = Server.CreateObject("ADODB.RecordSet") txtSQL = "SELECT * " & _ "FROM AssistantCoaches " & _ "WHERE AssistantCoaches.TeamName = 'Arsenal'" rstAsst.Open txtSQL, conn Set rstMgr = Server.CreateObject("ADODB.RecordSet") txtSQL = "SELECT * " & _ "FROM Managers " & _ "WHERE Managers.TeamName = 'Arsenal'" rstMgr.Open txtSQL, conn %> KFC Crush - Fire Blue

banner

Crush Home Tournaments About KFCKFC Store Crush Academy College Signees Contact Information Club Activities

Important Items

Field Status Hotline
and General Information:

(865) 777-2711

Practice Schedule
Day
Field
Time
Monday
   
Tuesday    
Wednesday    
Thursday    

 

Fire Blue
U13 Girls

2007/2008 STATE FINALIST

 


d

Knoxville FC Fire Blue
 
<%'There will always be a coach - but not always ans email%> <%If rstCoach.Fields("CoachEmail") <> "" Then%> <%Else%> <%End If%> <%'Loop thru the Assistant Coaches If NOT rstAsst.EOF Then icnt = 0 While NOT rstAsst.EOF icnt = icnt+1 'Put title only if 1st Asst Coach If icnt=1 Then%> <%Else%> <%End If txtAsstEmail = rstAsst.Fields("AsstCoachEmail") & "" If txtAsstEmail <> "" Then txtAsstEmail = "" End If %> <% rstAsst.MoveNext%> <%Wend Else 'Not any Asst Coaches%> <%End If%> <%'Loop thru the Managers If NOT rstMgr.EOF Then icnt = 0 While NOT rstMgr.EOF icnt = icnt+1 'Put title only if 1st Asst Coach If icnt=1 Then%> <%Else%> <%End If txtMgrEmail = rstMgr.Fields("ManagerEmail") & "" If txtMgrEmail <> "" Then txtMgrEmail = "" End If %> <% rstMgr.MoveNext%> <%Wend Else 'Not any Asst Coaches%> <%End If%>
Coach:
Shane Moore
Assistant Coach:
Elaine Roth
Assistant Coach:
Tony Riggs
Manager:
 
 
q

TOURNAMENT SCHEDULES/RESULTS
Spring 2008
Tournament Location Date Result
Vulcan Cup (Gold Division)
 Birmingham, AL Mar 7-9 1-2-0

adidas Spring Cup

 Knoxville, TN

Apr 4-6

rain

adidas Women's Invitational

Brentwood, TN

Apr 11-13

rain

Soccer Elite Spring Championship

Memphis, TN

Apr 26-27

 

TN State Championship

Hendersonville, TN

May 17-18

FALL 2007
Tournament Location Date Result
Huntsville Summer Classic
 Huntsville, AL Aug 10-12 CHAMPION

Ohio Premier Invitational (Top Flight)

 Dublin, OH

Sep 1-3

DNA

Adidas Fall Cup

Knoxville, TN

Oct 12-14

CHAMPION

Disney Jr Showcase (Showcase Flight)

Orlando, FL

Nov 23-25

DNA

Help/Contact Us | Home | Academy | Teams | News | Site Map 

KNOXVILLE FOOTBALL CLUB •  PO BOX 52888 •  KNOXVILLE,TN 37950  •   865.777.2711

WWW.KFCCRUSH.COM