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