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-11-14') AND date_add('1997-11-14',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

<< November 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 11/14
A Freedom (Morganton) 21
H A.C. Reynolds (Asheville) 14
A Rosman 14
H Albemarle 12
A Swansea
H Allendale-Fairfax
A Davie County 22
H Ashbrook (Gastonia) 15
A A.L. Brown (Kannapolis) 21
H Asheville 6
A Ledford (Thomasville) 7
H Bandys (Catawba) 34
A Andrews
H Barnwell
A Fairfield Central
H Beaufort
A Mauldin
H Berkeley (Moncks Corner)
A Latta
H Blackville-Hilda
A Calhoun Falls
H Buford (Lancaster)
A Union (Clinton)
H Bunn
A Enka (Candler)
H Burns (Lawndale)
A Lancaster
H Byrnes (Duncan)
A Kinston 14
H Carver (Winston-Salem) 20
A Rocky Mount 7
H Cary 9
A Crescent (Iva)
H Central (Pageland)
A Seneca
H Chester
A Midland Valley
H Clinton
A Southern Vance 0
H Clinton 54
A Abbeville
H Columbia
A West Forsyth 7
H Crest (Boiling Springs) 10
A South Stanly 14
H Cummings (Burlington) 46
A York
H Daniel (Central)
A Stall (Charleston)
H Dillon
A Conway
H Dorman (Roebuck)
A Eastern Wayne 12
H Douglas Byrd (Fayetteville) 41
A Havelock
H Dudley (Greensboro)
A Laurens
H Dutch Fork (Irmo)
A Hertford County 41
H East Chapel Hill 7
A Northern Vance
H East Duplin
A South Caldwell 14
H East Rowan 24
A Hayesville 28
H East Surry 12
A Chase (Forest City) 0
H Eastern Randolph 35
A Warren County
H Fairmont
A North Henderson 0
H Forest Hills (Marshville) 3
A Smithfield-Selma
H Fred T. Foard (Newton)
A Hillcrest (Simpsonville)
H Gaffney
A Seventy-First (Fayetteville) 6
H Garner 17
A Northside (Pinetown)
H Gates County
A Starmount (Boonville) 28
H Graham 6
A Boiling Springs
H Hartsville
A Shelby 49
H Hibriten (Lenoir) 14
A Sun Valley (Indian Trail) 21
H Hickory 61
A Surry Central 12
H High Point Central 28
A Ridge View (Columbia)
H Hilton Head
A Harnett Central
H Hunt (Wilson)
A Richland Northeast
H Irmo
A Jones 0
H James Kenan (Warsaw) 44
A T.W. Andrews (High Point) 20
H Kings Mountain 30
A Lugoff-Elgin
H Kingstree
A Williston-Elko
H Lake View
A Hoke County 7
H Laney (Wilmington) 28
A Stratford (Goose Creek)
H Lexington
A Robbinsville 8
H Maiden 29
A Easley
H Marlboro County
A Wake Forest 21
H Millbrook (Raleigh) 46
A Owen (Black Mountain) 53
H Monroe 6
A Concord 42
H Mooresville 28
A Hunter Huss (Gastonia) 10
H Mount Tabor (Winston-Salem) 36
A Mount Airy 20
H Murphy 14
A Chocowinity
H North Brunswick
A North Surry
H North Buncombe
A McCormick
H North Central (Kershaw)
A South Robeson
H North Duplin
A Pamlico County
H North Edgecombe
A Randleman 12
H North Rowan 14
A Camden County
H Northampton County West
A Southern Nash 23
H Northeast Guilford 28
A Cape Fear (Fayetteville) 8
H Northern Durham 28
A Lower Richland
H Northwestern (Rock Hill)
A Independence (Charlotte) 12
H Page (Greensboro) 15
A Enloe (Raleigh) 7
H Person County 28
A Tuscola (Waynesville) 6
H Ragsdale (Jamestown) 7
A West Mecklenburg 28
H Richmond County 57
A Socastee (Myrtle Beach)
H Rock Hill
A North Pitt
H Saint Pauls
A Andrew Jackson (Kershaw)
H Saluda
A J.H. Rose (Greenville)
H Sanderson (Raleigh)
A Providence (Charlotte) 0
H Scotland 35
A Mullins
H Silver Bluff (Aiken)
A Holmes (Edenton) 13
H South Columbus 35
A Greene Central 20
H Southwest Onslow 25
A Sumter
H Spartanburg
A Hannah Pamplico
H St. John's
A Brevard 23
H Statesville 14
A Orangeburg-Wilkinson
H Summerville
A Elkin 6
H Thomasville 52
A Belton-Honea Path
H Union County
A J.F. Webb (Oxford) 38
H Walter Williams (Burlington) 35
A Midway (Dunn)
H Weldon
A Reidsville 0
H West Brunswick 14
A Grimsley (Greensboro) 27
H West Charlotte 49
A Tarboro 19
H Western Alamance 38
A Washington
H Western Guilford
A Lakewood (Sumter)
H Westside (Anderson)
A Airport (West Columbia)
H Wilson (Florence)
A Mid-Carolina (Prosperity)
H Woodruff