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 = 3 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 ('2004-11-05') AND date_add('2004-11-05',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 2004 >>
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/05
A North Iredell 8
H A.L. Brown (Kannapolis) 28
A Palmetto (Williamston)
H Abbeville
A South Aiken
H Aiken
A Manning
H Airport (West Columbia)
A Thomasville 14
H Albemarle 20
A South Caldwell 26
H Alexander Central 27
A Kingstree
H Andrew Jackson (Kershaw)
A Hayesville 35
H Andrews 13
A Hunter Huss (Gastonia) 0
H Ashbrook (Gastonia) 43
A Eastern Randolph 28
H Asheboro 7
A Erwin (Asheville) 14
H Asheville 52
A Laney (Wilmington) 21
H Ashley (Wilmington) 16
A Enloe (Raleigh) 49
H Athens Drive (Raleigh) 30
A Madison County 6
H Avery County 34
A Farmville Central 6
H Ayden-Grifton 27
A Cheraw
H Aynor
A Bethune-Bowman
H Bamberg-Ehrhardt
A Bunker Hill (Claremont) 28
H Bandys (Catawba) 35
A Andrews
H Barnwell
A Columbia
H Batesburg-Leesville
A West Ashley
H Berkeley (Moncks Corner)
A Hertford County 7
H Bertie County 0
A Camden Military 21
H Bessemer City 23
A Calhoun Falls
H Blacksburg
A Pisgah (Canton) 8
H Brevard 16
A West-Oak (Westminster)
H Broome (Spartanburg)
A Boiling Springs
H Byrnes (Duncan)
A Columbia 14
H Camden County 57
A Christ School (Arden) 13
H Cardinal Gibbons (Raleigh) 22
A Darlington
H Carolina Forest (Myrtle Beach)
A Lee Central
H Carvers Bay (Hemingway)
A Lee County 22
H Cary 19
A Mullins
H Central (Pageland)
A North Mecklenburg 42
H Central Cabarrus 7
A Salisbury 41
H Central Davidson 20
A Monroe 14
H Charlotte Catholic 41
A Bishop McGuinness (Kernersville) 17
H Charlotte Latin 49
A Asheville School 16
H Charlotte Providence Day 46
A West Lincoln 13
H Chase (Forest City) 26
A North Lincoln 18
H Cherryville 23
A Liberty
H Chesnee
A Chester
H Clinton
A Fairfield Central
H Clover
A J.M. Robinson (Concord) 14
H Concord 32
A R-S Central 0
H Crest (Boiling Springs) 35
A Jamesville 28
H Creswell 6
A Havelock 27
H D.H. Conley (Greenville) 20
A Mann (Greenville)
H Daniel (Central)
A Wilson (Florence)
H Dillon
A Pamlico County 63
H Dixon 6
A Spartanburg
H Dorman (Roebuck)
A Pinecrest (Southern Pines) 6
H Douglas Byrd (Fayetteville) 40
A Cape Fear (Fayetteville) 6
H E.E. Smith (Fayetteville) 28
A South Brunswick 0
H East Bladen 33
A Freedom (Morganton) 10
H East Burke 7
A Southern Durham 51
H East Chapel Hill 0
A Croatan (Newport) 41
H East Duplin 56
A Grimsley (Greensboro) 34
H East Forsyth 14
A South Point (Belmont) 47
H East Lincoln 14
A North Surry 25
H East Surry 19
A Garner 47
H East Wake 49
A South Stokes 6
H East Wilkes 33
A Cedar Ridge (Hillsborough) 24
H Eastern Alamance 23
A Western Guilford 45
H Eastern Guilford 6
A Starmount (Boonville) 15
H Elkin 7
A Smoky Mountain (Sylva) 0
H Enka (Candler) 28
A Hunt (Wilson) 7
H Fike (Wilson) 10
A North Wilkes 0
H Forbush (East Bend) 48
A East Gaston 21
H Forestview (Gastonia) 19
A Battery Creek (Beaufort)
H Fort Dorchester (N. Charleston)
A Northampton County East 26
H Franklinton 6
A Green Hope (Morrisville) 51
H Fuquay-Varina 0
A York
H Gaffney
A Perquimans 33
H Gates County 48
A Carver (Winston-Salem) 14
H Glenn (Kernersville) 0
A James Island (Charleston)
H Goose Creek
A T.W. Andrews (High Point) 31
H Graham 42
A Timmonsville
H Green Sea-Floyds
A South Lenoir 6
H Greene Central 41
A Laurens
H Greenwood
A Lugoff-Elgin
H Greer
A Conway
H Hartsville
A Polk County 25
H Hendersonville 14
A West Caldwell 0
H Hibriten (Lenoir) 22
A Fred T. Foard (Newton) 13
H Hickory 33
A Southeast Guilford 14
H High Point Central 35
A Mauldin
H Hillcrest (Simpsonville)
A Bartlett Yancey 0
H Hillside (Durham) 50
A Beaufort 41
H Hilton Head 0
A Harding (Charlotte) 6
H Hopewell (Huntersville) 31
A Dutch Fork (Irmo)
H Irmo
A Southern Alamance 28
H J.F. Webb (Oxford) 14
A New Bern 34
H J.H. Rose (Greenville) 28
A White Oak (Jacksonville) 14
H Jacksonville 21
A South Davidson 0
H Jordan-Matthews (Siler City) 25
A Independence (Charlotte) 55
H Julius Chambers (Charlotte) 7
A Eastern Wayne 6
H Kinston 28
A Hannah Pamplico
H Lake View
A Union (Clinton) 32
H Lakewood (Salemburg) 22
A Johnsonville
H Lamar
A Fort Mill
H Lancaster
A Fayetteville Trinity Christian 32
H Lawrence Academy (Merry Hill) 8
A West Stokes 22
H Ledford (Thomasville) 52
A Wagener-Salley
H Lewisville
A White Knoll (Lexington)
H Lexington
A East Davidson 6
H Lexington 32
A East Rutherford 35
H Lincolnton 6
A North Edgecombe 8
H Louisburg 14
A Terry Sanford (Fayetteville) 13
H Lumberton 12
A Kings Mountain 7
H Maiden 36
A Currituck County 22
H Manteo 49
A Sumter
H Marlboro County
A Cape Hatteras 0
H Mattamuskeet (Swan Quarter) 27
A Calhoun County
H McBee
A A.C. Reynolds (Asheville) 31
H McDowell County 13
A Hobbton (Newton Grove) 22
H Midway (Dunn) 20
A Broughton (Raleigh) 31
H Millbrook (Raleigh) 38
A Mountain Heritage (Burnsville) 20
H Mitchell 30
A Northeast Guilford 54
H Morehead (Eden) 0
A Swain County 42
H Murphy 21
A Butler (Matthews) 14
H Myers Park (Charlotte) 7
A Marion
H Myrtle Beach
A Beddingfield (Wilson) 14
H Nash Central 13
A Hoggard (Wilmington) 6
H New Hanover 0
A Pelion
H Newberry
A Gilbert
H Ninety Six
A Swansboro 20
H North Brunswick 54
A Tuscola (Waynesville) 45
H North Buncombe 21
A Davie County 26
H North Davidson 13
A Spring Creek 0
H North Duplin 22
A Mount Tabor (Winston-Salem) 30
H North Forsyth 33
A Berry Academy (Charlotte) 0
H North Gaston 52
A East Montgomery 25
H North Moore 27
A Crestwood (Sumter)
H North Myrtle Beach
A SouthWest Edgecombe 58
H North Pitt 14
A Mount Airy 28
H North Stokes 0
A Holmes (Edenton) 48
H Northeastern (Elizabeth City) 10
A Southern Vance 36
H Northern Vance 6
A East Carteret 7
H Northside (Jacksonville) 21
A Southside (Chocowinity) 30
H Northside (Pinetown) 8
A Lake Norman 3
H Northwest Cabarrus 27
A Page (Greensboro) 6
H Northwest Guilford 42
A Warren County 36
H Northwest Halifax 14
A Rock Hill
H Northwestern (Rock Hill)
A Randleman 28
H Northwood (Pittsboro) 14
A Garinger (Charlotte) 0
H Olympic (Charlotte) 31
A Walter Williams (Burlington) 36
H Orange (Hillsborough) 17
A North Augusta
H Orangeburg-Wilkinson
A Southwest Guilford 6
H Parkland (Winston-Salem) 34
A Sun Valley (Indian Trail) 28
H Parkwood (Monroe) 8
A First Flight (Kill Devil Hills) 12
H Pasquotank County 33
A Jordan (Durham) 17
H Person County 16
A Williamston 18
H Plymouth 44
A Rosewood 48
H Princeton 6
A South Mecklenburg 12
H Providence (Charlotte) 52
A Pine Forest (Fayetteville) 21
H Purnell Swett (Pembroke) 26
A Trinity 0
H Ragsdale (Jamestown) 30
A McMichael (Mayodan) 0
H Reidsville 56
A Southwest Onslow 38
H Richlands 0
A Jack Britt (Fayetteville) 7
H Richmond County 20
A Lower Richland
H Ridge View (Columbia)
A Chapel Hill 16
H Riverside (Durham) 34
A Cherokee 8
H Robbinsville 41
A Dudley (Greensboro) 43
H Rockingham County 7
A Northern Nash 0
H Rocky Mount 40
A Fairmont 0
H Saint Pauls 34
A Wakefield (Raleigh) 23
H Sanderson (Raleigh) 35
A Westover (Fayetteville) 22
H Scotland 24
A Travelers Rest
H Seneca
A Hoke County 0
H Seventy-First (Fayetteville) 2
A Newton-Conover 14
H Shelby 49
A Bishop England (Charleston)
H Silver Bluff (Aiken)
A Clayton 46
H Smithfield-Selma 12
A West Carteret 25
H South Central (Winterville) 21
A East Columbus 6
H South Columbus 49
A Bunn 37
H South Granville 13
A West Johnston 63
H South Johnston 43
A Red Springs 13
H South Robeson 7
A North Rowan 6
H South Rowan 26
A West Davidson 48
H South Stanly 0
A Roanoke Rapids 26
H Southeast Halifax 20
A Union Pines (Cameron) 7
H Southwestern Randolph 58
A Richland Northeast
H Spring Valley (Columbia)
A Williston-Elko
H St. John's
A Burns (Lawndale) 40
H St. Stephens (Hickory) 7
A Mooresville 37
H Statesville 21
A Wando (Mt. Pleasant)
H Stratford (Goose Creek)
A Lake Marion
H Strom Thurmond (Johnston)
A Colleton County
H Summerville
A Alleghany 21
H Surry Central 27
A Emerald (Greenwood)
H Swansea
A Franklin 7
H T.C. Roberson (Asheville) 47
A North Lenoir 13
H Tarboro 38
A Chapin
H Timberland
A Lejeune 36
H Topsail 0
A Jones 14
H Trask (Rocky Point) 46
A Harnett Central 56
H Triton (Erwin) 35
A Camden
H Union County
A Belton-Honea Path
H Wade Hampton (Greenville)
A Leesville Road (Raleigh) 14
H Wake Forest 35
A James Kenan (Warsaw) 0
H Wallace-Rose Hill 63
A Landrum
H Ware Shoals
A C.B. Aycock (Pikeville) 52
H Washington 37
A Piedmont (Monroe) 23
H Weddington 10
A Northampton County West 6
H Weldon 14
A Clinton 14
H West Bladen 7
A Southern Wayne 28
H West Craven 27
A South Florence
H West Florence
A R.J. Reynolds (Winston-Salem) 27
H West Forsyth 13
A North Henderson 13
H West Henderson 12
A South Iredell 14
H West Iredell 31
A West Charlotte 40
H West Mecklenburg 27
A Forest Hills (Marshville) 35
H West Montgomery 7
A East Rowan 14
H West Rowan 28
A North Stanly 7
H West Stanly 21
A Wilkes Central 35
H West Wilkes 7
A Cummings (Burlington) 28
H Western Alamance 14
A Apex 37
H Western Harnett 13
A T.L. Hanna (Anderson)
H Westside (Anderson)
A West Columbus 0
H Whiteville 52
A Pendleton
H Woodruff
A Easley
H Wren (Piedmont)