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 = 17 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 ('2007-09-8') AND date_add('2007-09-8',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

<< September 2007 >>
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
      
Saturday's Game 09/08
A Dudley (Greensboro) 50
H Ben L. Smith (Greensboro) 7
Friday's Game 09/14
A Chester 8
H A.C. Flora (Columbia) 0
A Tuscola (Waynesville) 7
H A.C. Reynolds (Asheville) 53
A Anson 24
H A.L. Brown (Kannapolis) 21
A Pendleton 23
H Abbeville 28
A Bethune-Bowman ForfeitedForfeit
H Academic Magnet (N. Charleston) Double
A Ridge View (Columbia) 7
H Airport (W. Columbia) 22
A Fairmont 0
H Albemarle 30
A Edisto 7
H Allendale Fairfax 27
A North Central (Kershaw) 28
H Andrew Jackson (Kershaw) 20
A Carolina Forest (Myrtle Beach) 36
H Andrews 8
A Olympic (Charlotte) 20
H Ashbrook (Gastonia) 28
A Brevard 14
H Asheville 35
A Waccamaw (Georgetown) 27
H Aynor 26
A Burke (Charleston) 20
H Bamberg-Ehrhardt 48
A East Rutherford 34
H Bessemer City 20
A Fairfield Central 34
H Blythewood 44
A Easley 6
H Boiling Springs 14
A West Oak 19
H Broome (Spartanburg) 0
A Northeastern (Elizabeth City) 25
H Camden County 40
A North Gaston 24
H Charlotte Catholic 26
A Polk County 28
H Chase (Forest City) 0
A Marion 14
H Cheraw 49
A Pasquotank County
H Columbia Forfeited
A Hickory Ridge (Harrisburg) 14
H Concord 31
A Georgetown 13
H Conway 37
A Kings Mountain 18
H Crest (Boiling Springs) 45
A Kingstree 6
H Dillon 44
A North Duplin 49
H Dixon 0
A Wren (Piedmont) 2
H Dorman (Roebuck) 13
A E.E. Smith (Fayetteville)
H Douglas Byrd (Fayetteville) Forfeited
A White Knoll (Lexington) 20
H Dutch Fork (Irmo) 0
A Clinton 0
H East Bladen 14
A James Kenan (Warsaw) 19
H East Duplin 3
A Hopewell (Huntersville) 28
H East Gaston 0
A Charlotte Christian 38
H East Lincoln 14
A Carson (China Grove) 0
H East Rowan 27
A Ware Shoals 28
H Emerald (Greenwood) 20
A Owen (Black Mountain) 35
H Enka 28
A Highland Tech (Gastonia) 38
H Fayetteville Christian 16
A Wando (Mt. Pleasant) 7
H Fort Dorchester (N. Charleston) 33
A T.L. Hanna (Anderson) 0
H Gaffney 12
A North Mecklenburg ForfeitedForfeit
H Garinger (Charlotte) Double
A Perquimans 21
H Gates County 6
A Southern Wayne 40
H Goldsboro 12
A Colleton County 20
H Goose Creek 48
A Cary Christian 6
H Halifax Academy 42
A White Oak (Jacksonville) 10
H Havelock 7
A Rocky Mount 60
H Hertford County 28
A J.H. Rose (Greenville) 17
H Hoggard (Wilmington) 48
A South View (Hope Mills) 25
H Hoke County 8
A Vance (Charlotte) 0
H Independence (Charlotte) 28
A Lower Richland (Hopkins) 7
H Irmo 33
A Randleman 20
H Jordan-Matthews (Siler City) 56
A Greene Central 25
H Kinston 16
A West Iredell 14
H Lake Norman 13
A Green Sea-Floyds 0
H Lake View 42
A Darlington 7
H Lamar 36
A Hartsville 30
H Lancaster 19
A Lumberton 15
H Laney (Wilmington) 20
A North Brunswick 40
H Lejeune 20
A Sumter 56
H Lexington 42
A West Mecklenburg 29
H Mallard Creek (Charlotte) 0
A Louisburg 36
H Manteo 12
A North Myrtle Beach 7
H Marlboro County 12
A Lake City 0
H Myrtle Beach 35
A Fort Mill 32
H Nation Ford (Fort Mill) 0
A Southern Durham 17
H New Hanover (Wilmington) 8
A Chapin 6
H Newberry 28
A Mooresville 34
H North Iredell 6
A West Stokes 14
H North Surry 20
A North Augusta 14
H Northwestern (Rock Hill) 28
A Pine Forest (Fayetteville) 28
H Overhills 14
A Sun Valley (Monroe) 35
H Piedmont (Monroe) 7
A Ardrey Kell (Charlotte) 20
H Porter Ridge (Indian Trail) 7
A Scotland 16
H Purnell Swett (Pembroke) 12
A Jacksonville 14
H Richlands 9
A New Bern 13
H Richmond 24
A Mount Pleasant 35
H Robinson (Concord) 6
A Eastern Randolph 25
H Salisbury 29
A Lincolnton 13
H Shelby 35
A Timmonsville 12
H Socastee (Myrtle Beach) 40
A Strom Thurmond (Johnston) 16
H South Aiken 18
A Cardinal Gibbons (Raleigh) 13
H South Brunswick 18
A West Columbus 0
H South Columbus 52
A East Chapel Hill 6
H South Granville 34
A Jones Senior 6
H South Lenoir 0
A Burns (Lawndale) 7
H South Point (Belmont) 28
A Richland Northeast (Columbia) 18
H South Pointe (Rock Hill) 41
A Statesville 21
H South Rowan 12
A Pamlico County 38
H Southeast Halifax 0
A Hickory Grove Baptist (Charlotte) 20
H Southlake Christian 42
A Holmes (Edenton) 36
H Southside (Beaufort) 12
A Southern Guilford 14
H Southwestern Randolph 0
A Greenwood 7
H Spartanburg 2
A West Florence 14
H Spring Valley (Columbia) 6
A Wilson (Florence) 35
H St. James (Murrells Inlet) 0
A Swansboro 0
H St. Pauls 36
A Orangeburg-Wilkinson 6
H Summerville 49
A Freedom (Morganton) 6
H T.C. Roberson (Asheville) 33
A Harnett Central 0
H Terry Sanford (Fayetteville) 37
A Topsail 31
H Trask (Rocky Point) 14
A East Carteret 18
H Union 28
A Pender 25
H Wallace-Rose Hill 14
A Nash Central 7
H Washington 30
A Bunn 21
H Webb (Oxford) 20
A Franklinton 6
H Weldon 12
A Hobbton (Newton Grove) 14
H West Bladen 28
A Ashley (Wilmington) 42
H West Carteret 7
A North Wilkes 0
H West Lincoln 44
A Northwest Cabarrus 21
H West Rowan 46
A Cape Fear (Fayetteville) 34
H Western Harnett 14
A West Brunswick 0
H Whiteville 28