Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix W241AO Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2009-06-13 09:56:14" ["dmarank"]=> string(1) "0" ["dmaID"]=> string(1) "0" ["dmaType"]=> string(1) "C" ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(13) "United States" ["Population25up"]=> string(9) "300000000" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(2) "WW" }
Database: media
SQL: select * from cities where CityName = 'WYE MILLS' and State = 'MD'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754176245.3972
End: 1754176245.3977
Elapsed time: 0.5400 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('MD','Wye Mills',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80110" ["State"]=> string(2) "MD" ["CityName"]=> string(9) "Wye Mills" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> NULL ["Population"]=> NULL ["Latitude"]=> NULL ["Longitude"]=> NULL ["PrimaryAC"]=> NULL ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> NULL ["ISPCount"]=> NULL ["CovadDSL"]=> NULL ["VerizonDSL"]=> NULL ["allegiance"]=> NULL ["SBC"]=> NULL ["RateCenterCityid"]=> NULL ["Population2000"]=> NULL ["FIPS"]=> NULL ["cTZoffset"]=> NULL ["DST"]=> string(1) "0" ["DMAID"]=> NULL }
****** zip code ************
array(13) { ["zipcode"]=> string(5) "21679" ["zip3"]=> string(3) "216" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "WYE MILLS" ["zipstate"]=> string(2) "MD" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "38.91" ["iplongitude"]=> string(6) "-76.08" ["ziplocation"]=> string(18) "NA-US-MD-WYE MILLS" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "272" ["zippopulation"]=> string(3) "500" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "216" ["zipcity"]=> string(6) "EASTON" ["zipstate"]=> string(2) "MD" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "8024" ["State"]=> string(2) "MD" ["CityName"]=> string(6) "Easton" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(3) "168" ["Population"]=> string(4) "9372" ["Latitude"]=> string(9) "38.771594" ["Longitude"]=> string(10) "-76.070456" ["PrimaryAC"]=> string(3) "410" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "8024" ["Population2000"]=> string(5) "11708" ["FIPS"]=> string(7) "2424475" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
51 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
21601EASTONMD19388Easton
21613CAMBRIDGEMD13673Cambridge
21666STEVENSVILLEMD10970Stevensville
21620CHESTERTOWNMD9594Chestertown
21617CENTREVILLEMD8123Centreville
21629DENTONMD7338Denton
21619CHESTERMD5115Chester
21632FEDERALSBURGMD5102Federalsburg146
21643HURLOCKMD4935Hurlock146
21655PRESTONMD4360Preston
zipcodezipcityzipstatezippopulationcitynameDMAID
21638GRASONVILLEMD4211Grasonville21
21639GREENSBOROMD3629Greensboro
21658QUEENSTOWNMD3300Queenstown
21660RIDGELYMD3123Ridgely
21663SAINT MICHAELSMD2855Saint Michaels
21673TRAPPEMD2710Trappe
21651MILLINGTONMD2324Millington
21631EAST NEW MARKETMD2308East New Market
21661ROCK HALLMD2140Rock Hall
21625CORDOVAMD2130Cordova
zipcodezipcityzipstatezippopulationcitynameDMAID
21678WORTONMD1876
21635GALENAMD1757Galena
21623CHURCH HILLMD1457Church Hill
21668SUDLERSVILLEMD1369Sudlersville
21640HENDERSONMD1212Henderson
21654OXFORDMD1155Oxford
21649MARYDELMD1129Marydel
21657QUEEN ANNEMD1028Queen Anne
21636GOLDSBOROMD939Goldsboro
21645KENNEDYVILLEMD861
zipcodezipcityzipstatezippopulationcitynameDMAID
21659RHODESDALEMD806
21662ROYAL OAKMD722
21671TILGHMANMD655Tilghman
21634FISHING CREEKMD538
21679WYE MILLSMD500Wye Mills
21622CHURCH CREEKMD441Church Creek
21607BARCLAYMD0Barclay
21610BETTERTONMD0Betterton
21612BOZMANMD0
21626CRAPOMD0
zipcodezipcityzipstatezippopulationcitynameDMAID
21675WINGATEMD0Wingate
21627CROCHERONMD0
21644INGLESIDEMD0
21650MASSEYMD0
21647MCDANIELMD0
21665SHERWOODMD0
21667STILL PONDMD0Still Pond
21672TODDVILLEMD0
21676WITTMANMD0
21648MADISONMD0
zipcodezipcityzipstatezippopulationcitynameDMAID
21677WOOLFORDMD0
***** stations in DMA*************
26 records found!
stationidCallSignLicenseeServicecitynamexStatexcityid
22710BTRNWorld Wide WebWW79841
23163CRN1World Wide WebWW79841
23164CRN2World Wide WebWW79841
23165CRN3World Wide WebWW79841
23166CRN4World Wide WebWW79841
23167CRN5World Wide WebWW79841
23168CRN6World Wide WebWW79841
42585CSPAN1World Wide WebWW79841
42586CSPAN2World Wide WebWW79841
42587CSPAN3World Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
22711ESPNWorld Wide WebWW79841
58943EWTNWorld Wide WebWW79841
22652Fox NewsWorld Wide WebWW79841
22712Fox SportsWorld Wide WebWW79841
41312GCN1World Wide WebWW79841
41481GCN4World Wide WebWW79841
77684GCN5World Wide WebWW79841
32729MOYLWorld Wide WebWW79841
44298NPRWorld Wide WebWW79841
44299PRIWorld Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
22707Radio AmericaWorld Wide WebWW79841
44583SportsBylineWorld Wide WebWW79841
23558TalkStarWorld Wide WebWW79841
40372TammyRadioWorld Wide WebWW79841
44584TheBlazeWorld Wide WebWW79841
44301YSNWorld Wide WebWW79841
Station W241AO-FX
City WYE MILLS-MD

City Wye Mills, MD is located in DMAID: