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