SELECT G.away_team_score, G.home_team_score, G.Time, G.Date AS Gdate, G.score_entered, G.game_alter, G.ID AS GID, H.media_name AS HomeTeam, A.media_name AS AwayTeam, HTT.Abbreviation AS HomeTeamType, ATT.Abbreviation AS AwayTeamType, H.show_full_name AS HomeTeamShowFullName, A.show_full_name AS AwayTeamShowFullName, H.show_type AS HomeTeamShowType, A.show_type AS AwayTeamShowType, H.ID AS HID, A.ID AS AID, H.League=3 AS HOOS, A.League=3 AS AOOS, H.ZIPcode, G.Location, G.alternative_location FROM games AS G, high_schools AS H, high_schools AS A, high_school_types AS HTT,high_school_types AS ATT WHERE H.ID = G.home_team AND A.ID = G.away_team AND HTT.ID = H.Type AND ATT.ID = A.Type AND H.status=1 AND A.status=1 AND G.Season = 8 AND G.Sport = 1 AND (H.active_nc_team = 1 OR H.active_sc_team = 1) AND (A.active_nc_team = 1 OR A.active_sc_team = 1) AND DATE(G.Date) BETWEEN ('1997-10-03') AND date_add('1997-10-03',INTERVAL 6 DAY) ORDER BY G.Date, G.score_entered, H.media_name Chris Hughes' CarolinaPreps.com | Your Digital Destination for High School Football News & Information Array
Array

<< October 1997 >>
Su M Tu W Th F Sa
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
Friday's Game 10/03
A Ridge View (Columbia)
H A.C. Flora (Columbia)
A South Aiken
H Airport (West Columbia)
A C.A. Johnson (Columbia)
H Andrew Jackson (Kershaw)
A Loris
H Andrews
A Hoke County 28
H Anson County 21
A East Rutherford
H Asheville
A Sanderson (Raleigh) 24
H Athens Drive (Raleigh) 21
A Newton-Conover 0
H Bandys (Catawba) 40
A Allendale-Fairfax
H Barnwell
A Edisto (Cordova)
H Batesburg-Leesville
A James Island (Charleston)
H Beaufort
A C.B. Aycock (Pikeville)
H Beddingfield (Wilson)
A Ware Shoals
H Blacksburg
A Clover
H Broome (Spartanburg)
A Ben Lippen (Columbia)
H Buford (Lancaster)
A Northampton County East
H Bunn
A Independence (Charlotte) 47
H Butler (Matthews) 6
A Gilbert
H Calhoun County
A Pine Forest (Fayetteville) 6
H Cape Fear (Fayetteville) 42
A Western Guilford 3
H Carver (Winston-Salem) 20
A Abbeville
H Chapin
A Blue Ridge (Greer)
H Chapman (Inman)
A Chase (Forest City) 24
H Cherryville 20
A Southern Durham
H Clayton
A Swansboro 8
H Clinton 70
A Riverside (Greer)
H Clinton
A Chesterfield
H Columbia
A Central Cabarrus 7
H Concord 31
A South Florence
H Conway
A Burns (Lawndale) 2
H Crest (Boiling Springs) 42
A Lower Richland
H Crestwood (Sumter)
A Thomasville 42
H Cummings (Burlington) 6
A Belton-Honea Path
H Daniel (Central)
A North Davidson 24
H Davie County 40
A Lake City
H Dillon
A Byrnes (Duncan)
H Dorman (Roebuck)
A E.E. Smith (Fayetteville) 20
H Douglas Byrd (Fayetteville) 26
A Glenn (Kernersville)
H Dudley (Greensboro)
A Spring Valley (Columbia)
H Dutch Fork (Irmo)
A Alexander Central 0
H East Burke 28
A Bartlett Yancey 14
H East Chapel Hill 30
A East Carteret
H East Duplin
A Madison County
H East Henderson
A North Moore 20
H East Montgomery 42
A Harding (Charlotte) 0
H East Rowan 19
A North Stokes 0
H East Surry 35
A South Johnston
H East Wake
A Berea (Greenville)
H Eastside (Taylors)
A Broughton (Raleigh)
H Enloe (Raleigh)
A Camden
H Fairfield Central
A Hertford County
H Fike (Wilson)
A West Montgomery 12
H Forest Hills (Marshville) 35
A North Charleston
H Fort Dorchester (N. Charleston)
A York
H Fort Mill
A Roanoke
H Franklinton
A Rock Hill
H Gaffney
A Myers Park (Charlotte) 38
H Garinger (Charlotte) 6
A Triton (Erwin) 14
H Garner 37
A Columbia
H Gates County
A Pender County
H Goldsboro
A D.H. Conley (Greenville)
H Greene Central
A Hillcrest (Simpsonville)
H Greenwood
A Greenville
H Greer
A Fuquay-Varina
H Harnett Central
A Wake Christian 27
H Harrells Christian 12
A Wilson (Florence)
H Hartsville
A White Oak (Jacksonville)
H Havelock
A Cherokee 50
H Hendersonville 36
A East Lincoln 6
H Hickory 35
A East Davidson 13
H High Point Central 26
A Battery Creek (Beaufort)
H Hilton Head
A SouthWest Edgecombe
H Hunt (Wilson)
A Smithfield-Selma
H J.F. Webb (Oxford)
A Hobbton (Newton Grove) 16
H James Kenan (Warsaw) 33
A Olympic (Charlotte) 36
H Julius Chambers (Charlotte) 0
A Freedom (Morganton) 26
H Kings Mountain 21
A Dixon
H Lakewood (Salemburg)
A Richland Northeast
H Lakewood (Sumter)
A Sumter
H Lancaster
A Hoggard (Wilmington) 10
H Laney (Wilmington) 26
A Millbrook (Raleigh) 34
H Lee County 10
A Southeast Raleigh
H Leesville Road (Raleigh)
A Indian Land
H Lewisville
A Aiken
H Lexington
A Weldon
H Louisburg
A Keenan (Columbia)
H Lugoff-Elgin
A Lincolnton 0
H Maiden 38
A Manning
H Marion
A West Florence
H Marlboro County
A Timmonsville
H McBee
A Dixie (Due West) 15
H McCormick 63
A Alleghany 7
H Mitchell 27
A Sun Valley (Indian Trail) 10
H Monroe 7
A South Iredell 14
H Mooresville 42
A East Wilkes
H Mount Airy
A Randleman 33
H Mount Pleasant 6
A Hayesville 31
H Murphy 16
A Cheraw
H Myrtle Beach
A Eastern Wayne
H New Hanover
A Midland Valley
H Newberry
A Mid-Carolina (Prosperity)
H Ninety Six
A Great Falls
H North Central (Kershaw)
A Rosewood
H North Duplin
A West Forsyth 10
H North Forsyth 21
A Mountain Heritage (Burnsville)
H North Henderson
A Fred T. Foard (Newton) 34
H North Iredell 0
A Midway (Dunn)
H North Johnston
A Washington
H North Lenoir
A Hunter Huss (Gastonia) 14
H North Mecklenburg 6
A Mullins
H North Myrtle Beach
A Jones
H North Pitt
A Ledford (Thomasville) 40
H North Stanly 25
A McMichael (Mayodan)
H North Surry
A Forbush (East Bend)
H North Wilkes
A North Edgecombe
H Northampton County West
A Roanoke Rapids
H Northern Vance
A West Rowan 49
H Northwest Cabarrus 6
A Boiling Springs
H Northwestern (Rock Hill)
A Eastern Guilford 42
H Northwood (Pittsboro) 7
A North Augusta
H Orangeburg-Wilkinson
A Southwest Guilford 28
H Page (Greensboro) 33
A Ben L. Smith (Greensboro) 2
H Parkland (Winston-Salem) 18
A Charlotte Latin 35
H Parkwood (Monroe) 14
A Manteo
H Perquimans
A J.H. Rose (Greenville)
H Person County
A A.L. Brown (Kannapolis) 62
H Piedmont (Monroe) 12
A Richmond County 47
H Pinecrest (Southern Pines) 20
A Franklin
H Pisgah (Canton)
A Northside (Pinetown)
H Plymouth
A Andrews 14
H Polk County 6
A Topsail
H Princeton
A East Mecklenburg 13
H Providence (Charlotte) 14
A Lumberton
H Purnell Swett (Pembroke)
A Northwest Guilford 7
H Ragsdale (Jamestown) 41
A South Stokes 6
H Reidsville 36
A Rosman 15
H Robbinsville 20
A Northeast Guilford 42
H Rockingham County 0
A Lexington 35
H Salisbury 14
A Emerald (Greenwood)
H Saluda
A Southside (Greenville)
H Seneca
A Hope Mills South View 29
H Seventy-First (Fayetteville) 38
A Bessemer City 7
H Shelby 62
A Erwin (Asheville)
H Smoky Mountain (Sylva)
A Red Springs
H South Brunswick
A East Columbus 8
H South Columbus 47
A Bladenboro
H South Granville
A Jordan-Matthews (Siler City) 24
H South Stanly 20
A Riverside (Durham)
H Southeast Guilford
A Warren County
H Southeast Halifax
A Bertie County
H Southern Nash
A Northwest Halifax
H Southern Vance
A Jacksonville
H Southern Wayne
A Irmo
H Spartanburg
A South Caldwell
H St. Stephens (Hickory)
A Elkin
H Starmount (Boonville)
A Hibriten (Lenoir) 12
H Statesville 34
A Goose Creek
H Stratford (Goose Creek)
A Eau Claire (Columbia)
H Strom Thurmond (Johnston)
A Berkeley (Moncks Corner)
H Summerville
A Pelion
H Swansea
A Owen (Black Mountain)
H T.C. Roberson (Asheville)
A Easley
H T.L. Hanna (Anderson)
A Pamlico County
H Tarboro
A Westover (Fayetteville) 20
H Terry Sanford (Fayetteville) 12
A Burke (Charleston)
H Timberland
A Southern Guilford 35
H Trinity 36
A Enka (Candler)
H Tuscola (Waynesville)
A South Lenoir 7
H Union (Clinton) 24
A Chester
H Union County
A Mann (Greenville)
H Wade Hampton (Greenville)
A Cary
H Wake Forest
A Richlands
H Wallace-Rose Hill
A Morehead (Eden) 8
H Walter Williams (Burlington) 27
A McDowell County
H Watauga County
A Fairmont 6
H West Brunswick 49
A Farmville Central
H West Carteret
A South Mecklenburg 14
H West Charlotte 51
A East Bladen
H West Columbus
A Kinston
H West Craven
A Graham 55
H West Davidson 27
A R-S Central
H West Henderson
A Bunker Hill (Claremont) 50
H West Iredell 14
A East Gaston 15
H West Mecklenburg 20
A Wilkes Central
H West Wilkes
A Ravenscroft (Raleigh) 20
H Western Alamance 36
A Hillside (Durham)
H Western Harnett
A Laurens
H Westside (Anderson)
A Saint Pauls
H Whiteville
A Holmes (Edenton)
H Williamston
A Chesnee
H Woodruff
A Travelers Rest
H Wren (Piedmont)