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 = 2 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 ('2003-08-15') AND date_add('2003-08-15',INTERVAL 6 DAY) ORDER BY G.Date, G.score_entered, H.media_name Chris Hughes' CarolinaPreps.com Team Pages | Your Digital Destination for High School Football News & Information

<< August 2003 >>
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/15
A Ashe County 7
H Alleghany 9
A Monroe 28
H Anson 26
A Ledford 17
H Asheboro 7
A Leesville Road (Raleigh) 29
H Athens Drive (Raleigh) 10
A Reidsville 46
H Bartlett Yancey (Yanceyville) 0
A Bertie 28
H Beddingfield (Wilson) 44
A Grimsley (Greensboro) 19
H Ben L. Smith (Greensboro) 7
A Cherryville 15
H Bunker Hill 41
A Clayton 29
H C.B. Aycock (Pikeville) 0
A Jack Britt (Fayetteville) 28
H Cape Fear (Fayetteville) 7
A R.J. Reynolds (Winston-Salem) 34
H Carver (Winston-Salem) 45
A Broughton (Raleigh) 20
H Cary 6
A T.W. Andrews (High Point) 28
H Cedar Ridge 7
A Robinson (Concord) 21
H Central Cabarrus 6
A North Stanly 27
H Chatham Central 6
A Andrews 7
H Cherokee 42
A Northwest Cabarrus 20
H Concord 42
A Pamlico County 27
H Croatan (Newport) 8
A Thomasville 28
H Cummings (Burlington) 34
A Northside (Beaufort) 48
H Currituck County 10
A Alexander Central 7
H Davie County 29
A Western Harnett 0
H E.E. Smith (Fayetteville) 14
A South Lenoir 8
H East Carteret 29
A Brevard 23
H East Henderson 14
A Bandys (Catawba) 37
H East Lincoln 10
A Parkwood (Monroe) 7
H East Mecklenburg 41
A Salisbury 26
H East Rowan 0
A West Stokes 6
H East Surry 32
A Jordan (Durham) 0
H Eastern Randolph 30
A Surry Central 20
H Forbush 0
A South Mecklenburg 0
H Forestview (Gastonia) 54
A West Lincoln 14
H Fred T. Foard (Newton) 30
A Manteo 27
H Gates County 7
A Hibriten (Lenoir) 41
H Highland Tech (Gastonia) 8
A Northeast Guilford 54
H Hillside (Durham) 0
A Tarboro 8
H Holmes (Edenton) 10
A Washington 0
H J.H. Rose (Greenville) 47
A Rosewood 48
H Jones Senior 0
A Southwestern Randolph 32
H Jordan-Matthews (Siler City) 6
A North Pitt 0
H Kinston 13
A Western Alamance 29
H Lexington 0
A St. Pauls 34
H Lumberton 0
A Lincolnton 29
H Maiden 12
A Mitchell 28
H McDowell 26
A South Stokes 20
H McMichael (Mayodan) 22
A Garner
H Millbrook (Raleigh) Forfeited
A North Iredell 21
H Mount Airy 35
A North Gaston 9
H Murphy 8
A West Johnston 0
H Nash Central 16
A Goldsboro 0
H New Bern 48
A Mountain Heritage 6
H North Buncombe 9
A Central Davidson 22
H North Davidson 23
A Glenn (Kernersville) 10
H North Forsyth 0
A Charlotte Christian 47
H North Lincoln 6
A Elkin 42
H North Wilkes 0
A White Oak (Jacksonville) 23
H Northside (Jacksonville) 18
A Eastern Guilford 27
H Northwest Guilford 55
A SouthWest Edgecombe 40
H Northwest Halifax 14
A Union Pines (Cameron) 7
H Northwood (Pittsboro) 34
A Eastern Alamance 14
H Orange 6
A West Forsyth 17
H Parkland (Winston-Salem) 7
A Camden County 20
H Pasquotank County 6
A Topsail 0
H Pender 56
A Farmville Central 39
H Perquimans 0
A Olympic (Charlotte) 33
H Piedmont (Monroe) 41
A Douglas Byrd (Fayetteville) 35
H Purnell Swett (Pembroke) 0
A James Kenan (Warsaw) 14
H Red Springs 35
A Pine Forest (Fayetteville)
H Seventy-First (Fayetteville) Forfeited
A Middle Creek (Apex) 27
H Smithfield-Selma 20
A Franklinton 50
H South Granville 32
A Lake Norman 12
H South Iredell 0
A North Johnston 36
H South Johnston 24
A A.L. Brown (Kannapolis) 36
H South Rowan 37
A Mount Pleasant 42
H South Stanly 0
A Southeast Raleigh 43
H South View (Hope Mills) 0
A North Mecklenburg 0
H Southern Durham 14
A East Davidson 20
H Southern Guilford 39
A East Columbus 0
H Southwest Onslow 45
A Newton-Conover 24
H St. Stephens 19
A North Surry 13
H Starmount (Boonville) 30
A West Stanly 34
H Sun Valley (Monroe) 7
A Spring Creek 30
H Trask (Rocky Point) 32
A Green Hope (Cary) 26
H Wakefield (Raleigh) 7
A Graham 21
H Walter Williams (Burlington) 5
A West Caldwell 14
H Watauga 31
A Forest Hills (Marshville) 41
H Weddington 17
A Richlands 48
H West Carteret 6
A D.H. Conley (Greenville) 6
H West Craven 36
A Statesville 7
H West Iredell 13
A Avery 24
H West Wilkes 13
A Person (Roxboro) 34
H Western Guilford 20
A Gray's Creek (Hope Mills) 7
H Westover (Fayetteville) 27
A East Wilkes 13
H Wilkes Central 16
Thursday's Game 08/21
A Page (Greensboro) 20
H High Point Central 0