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-09-12') AND date_add('1997-09-12',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

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