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-8-24') AND date_add('1997-8-24',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

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