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-19') AND date_add('1997-8-19',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/22
A West Caldwell
H Alexander Central
A East Carteret
H Ayden-Grifton
A East Lincoln 0
H Bandys (Catawba) 42
A Person County 28
H Bartlett Yancey 6
A Rosman
H Brevard
A Cherryville 8
H Bunker Hill (Claremont) 29
A East Forsyth 0
H Carver (Winston-Salem) 14
A Broughton (Raleigh)
H Cary
A Eastern Randolph 28
H Central Cabarrus 11
A South Davidson 6
H Central Davidson 14
A Enloe (Raleigh) 28
H Chapel Hill 7
A Garinger (Charlotte) 0
H Concord 32
A Walter Williams (Burlington) 21
H Cummings (Burlington) 54
A Fred T. Foard (Newton) 45
H East Burke 30
A Southern Guilford 18
H East Davidson 21
A Southern Alamance 14
H Eastern Alamance 20
A Roanoke Rapids
H Franklinton
A Millbrook (Raleigh) 29
H Garner 22
A Reidsville 19
H Grimsley (Greensboro) 15
A Greene Central
H Havelock
A West Lincoln 0
H Hibriten (Lenoir) 7
A Bertie County
H Holmes (Edenton)
A Butler (Matthews) 21
H Julius Chambers (Charlotte) 12
A Southern Wayne
H Kinston
A West Montgomery 18
H Lexington 10
A St. Stephens (Hickory) 8
H Maiden 28
A Washington
H Manteo
A Wilkes Central
H Newton-Conover
A Mountain Heritage (Burnsville)
H North Buncombe
A Hickory 44
H North Gaston 3
A Mount Airy 47
H North Iredell 6
A Albemarle 19
H North Rowan 6
A Trinity 14
H North Stanly 34
A North Stokes
H North Wilkes
A Gates County
H Northampton County East
A Creswell
H Northampton County West
A Ben L. Smith (Greensboro) 0
H Northeast Guilford 54
A Perquimans
H Northeastern (Elizabeth City)
A Mattamuskeet (Swan Quarter)
H Northside (Pinetown)
A Mount Pleasant 13
H Northwest Cabarrus 7
A East Chapel Hill ForfeitedForfeit
H Northwood (Pittsboro) Double
A J.F. Webb (Oxford) 43
H Orange (Hillsborough) 0
A Forest Hills (Marshville) 51
H Piedmont (Monroe) 0
A Southeast Halifax
H Plymouth
A Ashbrook (Gastonia) 16
H Providence (Charlotte) 8
A West Iredell 21
H South Iredell 24
A Bessemer City 6
H South Point (Belmont) 35
A East Rowan 31
H South Rowan 0
A Riverside (Durham)
H Southern Durham
A Warren County
H Southern Nash
A Weldon
H Southern Vance
A East Montgomery 18
H Southwestern Randolph 7
A Randleman 0
H Thomasville 29
A McDowell County
H Tuscola (Waynesville)
A South Caldwell
H Watauga County
A White Oak (Jacksonville)
H West Carteret
A East Wilkes 28
H West Davidson 7
A Salisbury 0
H West Rowan 12
A Sun Valley (Indian Trail) 8
H West Stanly 15
A Graham 21
H Western Alamance 14
A Fairmont 14
H Westover (Fayetteville) 6
A Camden County
H Williamston