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-10') AND date_add('1997-10-10',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/10
A Fairfield Central
H A.C. Flora (Columbia)
A North Buncombe 7
H A.C. Reynolds (Asheville) 56
A West Rowan 7
H A.L. Brown (Kannapolis) 35
A West Davidson 20
H Albemarle 21
A McDowell County
H Alexander Central
A Elkin
H Alleghany
A Bamberg-Ehrhardt
H Allendale-Fairfax
A Hemingway
H Andrews
A Lumberton 20
H Anson County 56
A Triton (Erwin)
H Apex
A Olympic (Charlotte) 6
H Ashbrook (Gastonia) 23
A Lee County 7
H Athens Drive (Raleigh) 13
A Madison County
H Avery County
A North Pitt
H Ayden-Grifton
A Morehead (Eden) 21
H Bartlett Yancey 20
A Pelion
H Batesburg-Leesville
A Wren (Piedmont)
H Belton-Honea Path
A Christ Church (Greenville)
H Blacksburg
A Chester
H Broome (Spartanburg)
A Great Falls
H Buford (Lancaster)
A Weldon
H Bunn
A Garinger (Charlotte) 12
H Butler (Matthews) 27
A Aiken
H Byrnes (Duncan)
A Swansea
H Calhoun County
A McCormick
H Calhoun Falls
A Keenan (Columbia)
H Camden
A Mattamuskeet (Swan Quarter)
H Camden County
A East Wake
H Cary
A Chesterfield
H Central (Pageland)
A Piedmont (Monroe) 0
H Central Cabarrus 33
A Asheboro 16
H Central Davidson 13
A Jordan (Durham) 0
H Chapel Hill 52
A Carolina (Greenville)
H Chapman (Inman)
A Lake City
H Cheraw
A Woodmont (Piedmont)
H Chesnee
A Fuquay-Varina
H Clayton
A Southside (Greenville)
H Clinton
A East Carteret 0
H Clinton 42
A Chocowinity
H Columbia
A Andrew Jackson (Kershaw)
H Columbia
A Northwest Cabarrus 6
H Concord 47
A Darlington
H Conway
A Freedom (Morganton) 7
H Crest (Boiling Springs) 28
A North Moore 6
H Cummings (Burlington) 58
A Seneca
H Daniel (Central)
A West Forsyth 41
H Davie County 20
A Marion
H Dillon
A Landrum 25
H Dixie (Due West) 7
A Gaffney
H Dorman (Roebuck)
A Hope Mills South View 0
H Douglas Byrd (Fayetteville) 14
A Crestwood (Sumter)
H Dutch Fork (Irmo)
A Seventy-First (Fayetteville) 21
H E.E. Smith (Fayetteville) 14
A Fairmont
H East Bladen
A Watauga County 15
H East Burke 39
A Southern Alamance 19
H East Chapel Hill 20
A Richlands
H East Duplin
A Northwest Guilford
H East Forsyth
A Hunter Huss (Gastonia) 16
H East Gaston 7
A North Iredell 7
H East Lincoln 21
A Starmount (Boonville) 20
H East Surry 7
A North Stokes
H East Wilkes
A Northwood (Pittsboro) 0
H Eastern Randolph 48
A Mann (Greenville)
H Eastside (Taylors)
A Mid-Carolina (Prosperity)
H Emerald (Greenwood)
A C.B. Aycock (Pikeville)
H Fike (Wilson)
A Charlotte Catholic 0
H Forest Hills (Marshville) 28
A Goose Creek
H Fort Dorchester (N. Charleston)
A Clover
H Fort Mill
A Smoky Mountain (Sylva)
H Franklin
A North Edgecombe
H Franklinton
A Wake Forest 14
H Garner 21
A Creswell
H Gates County
A Edisto (Cordova)
H Gilbert
A Western Guilford
H Glenn (Kernersville)
A White Oak (Jacksonville)
H Goldsboro
A Easley
H Greenwood
A Smithfield-Selma
H Harnett Central
A West Florence
H Hartsville
A North Lenoir
H Havelock
A Rosman
H Hayesville
A Bunker Hill (Claremont) 20
H Hibriten (Lenoir) 28
A Salisbury 7
H High Point Central 23
A J.F. Webb (Oxford)
H Hillside (Durham)
A Jacksonville
H Hoggard (Wilmington)
A Northside (Pinetown)
H Holmes (Edenton)
A Bertie County
H Hunt (Wilson)
A East Mecklenburg 0
H Independence (Charlotte) 58
A North Central (Kershaw)
H Indian Land
A Rocky Mount
H J.H. Rose (Greenville)
A Rosewood 21
H James Kenan (Warsaw) 27
A North Mecklenburg 34
H Julius Chambers (Charlotte) 6
A Burns (Lawndale) 0
H Kings Mountain 28
A Burke (Charleston)
H Kingstree
A Washington
H Kinston
A Green Sea-Floyds
H Lake View
A Bladenboro
H Lakewood (Salemburg)
A Richland Northeast
H Lancaster
A Southern Wayne
H Laney (Wilmington)
A Broughton (Raleigh)
H Leesville Road (Raleigh)
A Topsail
H Lejeune
A Ben Lippen (Columbia)
H Lewisville
A Irmo
H Lexington
A Northampton County West
H Louisburg
A Sumter
H Lower Richland
A Chase (Forest City) 7
H Maiden 38
A Socastee (Myrtle Beach)
H Marlboro County
A Eastern Guilford
H McMichael (Mayodan)
A Enloe (Raleigh)
H Millbrook (Raleigh)
A Mountain Heritage (Burnsville) 14
H Mitchell 6
A South Caldwell 7
H Mooresville 29
A Parkwood (Monroe) 20
H Mount Pleasant 14
A R.J. Reynolds (Winston-Salem) 10
H Mount Tabor (Winston-Salem) 12
A Manning
H Myrtle Beach
A Northeastern (Elizabeth City)
H New Bern
A Abbeville
H Ninety Six
A Airport (West Columbia)
H North Augusta
A Dixon
H North Brunswick
A North Johnston
H North Duplin
A Page (Greensboro) 34
H North Forsyth 10
A Owen (Black Mountain)
H North Henderson
A Loris
H North Myrtle Beach
A Ledford (Thomasville) 13
H North Rowan 30
A East Davidson 7
H North Stanly 18
A Roanoke
H Northampton County East
A Walter Williams (Burlington) 27
H Northeast Guilford 49
A Person County
H Northern Durham
A D.H. Conley (Greenville)
H Northern Nash
A Southeast Halifax
H Northern Vance
A Spartanburg
H Northwestern (Rock Hill)
A Riverside (Durham) 35
H Orange (Hillsborough) 0
A South Aiken
H Orangeburg-Wilkinson
A Jones
H Pamlico County
A Dudley (Greensboro) 26
H Parkland (Winston-Salem) 13
A Currituck County
H Perquimans
A Scotland 31
H Pinecrest (Southern Pines) 21
A Erwin (Asheville)
H Pisgah (Canton)
A Hendersonville 20
H Polk County 0
A Midway (Dunn)
H Princeton
A South Mecklenburg 16
H Providence (Charlotte) 28
A East Rutherford
H R-S Central
A North Davidson 21
H Ragsdale (Jamestown) 26
A Union Pines (Cameron) 28
H Randleman 32
A Eastern Alamance 7
H Reidsville 12
A Hoke County 0
H Richmond County 43
A Lugoff-Elgin
H Ridge View (Columbia)
A Greer
H Riverside (Greer)
A Murphy 14
H Robbinsville 28
A Boiling Springs
H Rock Hill
A Chapin
H Saluda
A Cherryville 20
H Shelby 62
A West Columbus
H South Brunswick
A Saint Pauls 38
H South Columbus 12
A East Montgomery 22
H South Davidson 18
A Wilson (Florence)
H South Florence
A Northwest Halifax
H South Granville
A Hickory 52
H South Iredell 13
A Farmville Central 45
H South Lenoir 12
A North Gaston 7
H South Point (Belmont) 34
A Union (Clinton)
H South Robeson
A South Stokes 7
H South Rowan 38
A Grimsley (Greensboro) 38
H Southeast Guilford 19
A Sanderson (Raleigh)
H Southeast Raleigh
A Hertford County
H Southern Nash
A Warren County
H Southern Vance
A Beddingfield (Wilson)
H SouthWest Edgecombe
A Ben L. Smith (Greensboro)
H Southwest Guilford
A West Montgomery 40
H Southwestern Randolph 0
A Lakewood (Sumter)
H Spring Valley (Columbia)
A Fred T. Foard (Newton)
H St. Stephens (Hickory)
A Newton-Conover 8
H Statesville 30
A North Charleston
H Stratford (Goose Creek)
A Newberry
H Strom Thurmond (Johnston)
A Wando (Mt. Pleasant)
H Summerville
A Harding (Charlotte) 20
H Sun Valley (Indian Trail) 21
A North Surry
H Surry Central
A Andrews 6
H Swain County 53
A East Henderson
H T.C. Roberson (Asheville)
A Hillcrest (Simpsonville)
H T.L. Hanna (Anderson)
A Red Springs
H Tar Heel
A Greene Central
H Tarboro
A Pine Forest (Fayetteville) 21
H Terry Sanford (Fayetteville) 13
A South Stanly 0
H Thomasville 42
A Georgetown
H Timberland
A Berea (Greenville)
H Travelers Rest
A T.W. Andrews (High Point) 0
H Trinity 14
A Brevard
H Tuscola (Waynesville)
A York
H Union County
A Greenville
H Wade Hampton (Greenville)
A Arendell-Parrott (Kinston) 14
H Wake Christian 18
A Southwest Onslow 28
H Wallace-Rose Hill 22
A Whiteville 7
H West Brunswick 46
A New Hanover
H West Carteret
A Myers Park (Charlotte) 7
H West Charlotte 42
A Pender County
H West Craven
A Asheville
H West Henderson
A West Caldwell 42
H West Iredell 0
A Bessemer City 19
H West Lincoln 6
A Monroe 39
H West Stanly 35
A Southern Guilford 0
H Western Alamance 38
A Southern Durham
H Western Harnett
A Cape Fear (Fayetteville) 13
H Westover (Fayetteville) 7
A Mauldin
H Westside (Anderson)
A Forbush (East Bend)
H Wilkes Central
A Manteo
H Williamston
A Hunter-Kinard-Tyler
H Williston-Elko
A Blue Ridge (Greer)
H Woodruff