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 = 15 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 ('2006-08-18') AND date_add('2006-08-18',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 2006 >>
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/18
A Enka 0
H A.C. Reynolds (Asheville) 60
A Beaufort 7
H Aiken 14
A North Iredell 22
H Alexander Central 25
A Pelion 31
H Andrews 7
A Cherokee 54
H Andrews 14
A West Mecklenburg 15
H Ashbrook (Gastonia) 39
A Alleghany 6
H Ashe County 71
A Ben L. Smith (Greensboro) 51
H Atkins (Winston-Salem) 13
A West Wilkes 3
H Avery 14
A Pamlico County 14
H Ayden-Grifton 26
A Lake Norman 7
H Bandys (Catawba) 13
A Northern Nash 0
H Beddingfield (Wilson) 47
A North Mecklenburg 44
H Berry (Charlotte) 6
A Hunt (Wilson) 13
H Bertie 18
A R-S Central 21
H Bessemer City 6
A Highland Tech (Gastonia) 27
H Bishop McGuinness (Kernersville) 12
A Rosman 0
H Brevard 40
A Cary 29
H Broughton (Raleigh) 20
A Hartsville 20
H Byrnes (Duncan) 55
A Pasquotank County 22
H Camden County 35
A Chapel Hill 38
H Cedar Ridge 6
A North Stanly 27
H Central Davidson 17
A Carolina Bearcats 18
H Charlotte Christian 54
A North Stokes 24
H Chatham Central 14
A Bunker Hill 14
H Cherryville 28
A Wilson (Florence) 35
H Clover 36
A Vance (Charlotte) 39
H Concord 14
A Topsail 27
H Croatan (Newport) 21
A Manteo 46
H Currituck County 3
A North Forsyth 14
H Davie County 42
A Purnell Swett (Pembroke) 23
H Douglas Byrd (Fayetteville) 14
A Carver (Winston-Salem) 6
H Dudley (Greensboro) 7
A Tuscola (Waynesville) 10
H East Burke 30
A Southern Guilford 0
H East Davidson 21
A East Gaston 26
H East Lincoln 33
A North Wilkes
H Elkin Forfeited
A West Iredell 20
H Forbush 6
A Weddington 20
H Forest Hills (Marshville) 16
A Forestview (Gastonia) 10
H Fort Mill 28
A South Caldwell 10
H Fred T. Foard (Newton) 0
A Millbrook (Raleigh) 19
H Garner 40
A Rocky Mount 40
H Goldsboro 24
A Morehead (Eden) 22
H Graham 21
A D.H. Conley (Greenville) 6
H Greene Central 30
A Western Guilford 20
H Grimsley (Greensboro) 41
A Jacksonville 10
H Harnett Central 42
A Southlake Christian 12
H Harrells Christian 22
A Franklin 30
H Hayesville 13
A Smoky Mountain 21
H Hendersonville 13
A Kinston 15
H Hertford County 38
A Wilkes Central 13
H Hibriten (Lenoir) 27
A E.E. Smith (Fayetteville) 18
H Hoke County 16
A Perquimans 6
H Holmes (Edenton) 41
A East Mecklenburg 22
H Hopewell (Huntersville) 20
A East Henderson 28
H Hunter Huss (Gastonia) 42
A Cape Fear (Fayetteville) 14
H Jack Britt (Fayetteville) 20
A East Duplin 7
H James Kenan (Warsaw) 22
A Eastern Randolph 33
H Jordan (Durham) 22
A Southwestern Randolph 0
H Jordan-Matthews (Siler City) 50
A Middle Creek (Apex) 14
H Knightdale 15
A Scotland 37
H Lee County 14
A Swansboro 0
H Lejeune 13
A St. Stephens 21
H Lincolnton 35
A Erwin (Asheville) 8
H Madison 14
A North Lincoln 13
H Maiden 14
A Richmond 28
H Marlboro County 7
A T.C. Roberson (Asheville) 33
H McDowell 18
A Chase (Forest City) 18
H Mitchell 14
A Anson 42
H Monroe 10
A Garinger (Charlotte) 0
H Myers Park (Charlotte) 42
A Mt. Tabor (Winston-Salem) 9
H New Bern 7
A Southeast Raleigh 21
H New Hanover (Wilmington) 14
A Mountain Heritage 20
H North Buncombe 26
A A.L. Brown (Kannapolis) 31
H North Davidson 14
A Polk County 50
H North Henderson 14
A Union 28
H North Johnston 7
A Albemarle 6
H North Rowan 41
A Lexington 6
H North Surry 9
A Hillside (Durham) 32
H Northeast Guilford 7
A First Flight (Kill Devil Hills) 35
H Northside (Beaufort) 0
A Southwest Guilford 34
H Northwest Guilford 17
A Smithfield-Selma 27
H Overhills 20
A Fairmont 12
H Pender 18
A Wren (Piedmont) 10
H Pendleton 14
A Eastern Guilford 27
H Person (Roxboro) 33
A Easley 19
H Pickens 13
A Olympic (Charlotte) 33
H Piedmont (Monroe) 0
A Seventy-First (Fayetteville) 35
H Pine Forest (Fayetteville) 0
A East Rutherford 20
H Porter Ridge (Indian Trail) 6
A South Johnston 41
H Princeton 15
A South Davidson 14
H Randleman 33
A Jones Senior 14
H Richlands 28
A Mount Pleasant 6
H Robinson (Concord) 17
A South Aiken 10
H Rock Hill 13
A South Rowan 13
H Salisbury 41
A Clayton 18
H Sanderson (Raleigh) 22
A Bunn 24
H South Granville 11
A Newton-Conover 41
H South Iredell 12
A Charlotte Catholic 15
H South Mecklenburg 8
A Rockingham County 41
H South Stokes 0
A Westover (Fayetteville) 12
H South View (Hope Mills) 43
A Franklinton 7
H Southeast Halifax 34
A Cummings (Burlington) 48
H Southern Alamance 14
A High Point Central 13
H Southern Durham 34
A Athens Drive (Raleigh) 61
H Southern Lee 33
A East Columbus 6
H Southwest Onslow 38
A South Lenoir 25
H Spring Creek 6
A Lumberton 33
H St. Pauls 12
A Mount Airy 36
H Starmount (Boonville) 15
A Carson (China Grove) 0
H Sun Valley (Monroe) 41
A Ledford 19
H Surry Central 28
A Reidsville 36
H T.W. Andrews (High Point) 7
A Nash Central 12
H Tarboro 10
A Triton (Erwin) 19
H Terry Sanford (Fayetteville) 34
A Clinton 0
H Thomasville 36
A Northwood (Pittsboro) 35
H Union Pines (Cameron) 13
A Riverside (Durham) 18
H Wake Forest 16
A Orange 6
H Walter Williams (Burlington) 42
A North Pitt 0
H Washington 34
A Warren County 12
H Webb (Oxford) 35
A Watauga 35
H West Caldwell 9
A C.B. Aycock (Pikeville) 40
H West Carteret 14
A Independence (Charlotte) 17
H West Charlotte 6
A Dixon 25
H West Columbus 41
A Southern Wayne 49
H West Craven 40
A East Wilkes 6
H West Davidson 20
A Parkland (Winston-Salem) 14
H West Forsyth 13
A Hoggard (Wilmington) 47
H West Johnston 14
A North Gaston 44
H West Lincoln 6
A Central Cabarrus 14
H West Stanly 21
A East Surry 27
H West Stokes 32
A Eastern Alamance 27
H Western Alamance 45
A Fuquay-Varina 41
H Western Harnett 13
A Northside (Jacksonville) 42
H White Oak (Jacksonville) 0
A West Bladen 0
H Whiteville 21
A Laurens 14
H York 6
Saturday's Game 08/19
A Wakefield (Raleigh) 16
H Green Hope (Cary) 7