Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WXRB FM Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9998" ["dmaType"]=> NULL ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(7) "Unrated" ["Population25up"]=> string(1) "0" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(0) "" }
Database: media
SQL: select * from cities where CityName = 'DUDLEY' and State = 'MA'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const3Using where


Number of rows returned = 0
Start: 1754176660.5366
End: 1754176660.5371
Elapsed time: 0.4749 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('MA','Dudley',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80138" ["State"]=> string(2) "MA" ["CityName"]=> string(6) "Dudley" ["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) "01571" ["zip3"]=> string(3) "015" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "DUDLEY" ["zipstate"]=> string(2) "MA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "42.05" ["iplongitude"]=> string(6) "-71.93" ["ziplocation"]=> string(15) "NA-US-MA-DUDLEY" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "5172" ["zippopulation"]=> string(4) "9200" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "015" ["zipcity"]=> string(10) "SHREWSBURY" ["zipstate"]=> string(2) "MA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "7718" ["State"]=> string(2) "MA" ["CityName"]=> string(10) "Shrewsbury" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "49" ["Population"]=> NULL ["Latitude"]=> string(9) "42.364807" ["Longitude"]=> string(10) "-71.896868" ["PrimaryAC"]=> string(3) "508" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "7718" ["Population2000"]=> NULL ["FIPS"]=> NULL ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
43 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
01545SHREWSBURYMA30759Shrewsbury
01581WESTBOROUGHMA16691Westborough
01501AUBURNMA14232Auburn
01550SOUTHBRIDGEMA13355Southbridge110
01570WEBSTERMA13308Webster110
01532NORTHBOROUGHMA13113Northborough
01520HOLDENMA12865Holden
01527MILLBURYMA11467Millbury
01510CLINTONMA11365Clinton
01569UXBRIDGEMA11159Uxbridge
zipcodezipcityzipstatezippopulationcitynameDMAID
01507CHARLTONMA10873Charlton
01562SPENCERMA9747Spencer
01540OXFORDMA9660Oxford
01571DUDLEYMA9200Dudley
01588WHITINSVILLEMA7937Whitinsville
01504BLACKSTONEMA7808Blackstone
01590SUTTONMA7702
01516DOUGLASMA7565
01564STERLINGMA7104Sterling
01543RUTLANDMA6893Rutland
zipcodezipcityzipstatezippopulationcitynameDMAID
01568UPTONMA6440Upton
01519GRAFTONMA6093Grafton
01583WEST BOYLSTONMA5947West Boylston
01566STURBRIDGEMA5934Sturbridge
01536NORTH GRAFTONMA5828
01524LEICESTERMA5678Leicester
01534NORTHBRIDGEMA4939
01523LANCASTERMA4777
01505BOYLSTONMA3993Boylston
01535NORTH BROOKFIELDMA3925North Brookfield
zipcodezipcityzipstatezippopulationcitynameDMAID
01560SOUTH GRAFTONMA3675
01585WEST BROOKFIELDMA3585West Brookfield
01541PRINCETONMA3224Princeton
01522JEFFERSONMA2984
01506BROOKFIELDMA2920
01529MILLVILLEMA2734
01518FISKDALEMA2639Fiskdale
01503BERLINMA2462Berlin
01521HOLLANDMA2069Holland
01515EAST BROOKFIELDMA1985East Brookfield
zipcodezipcityzipstatezippopulationcitynameDMAID
01537NORTH OXFORDMA1951
01542ROCHDALEMA1907
01531NEW BRAINTREEMA865
Station WXRB-FM
City DUDLEY-MA

City Dudley, MA is located in DMAID: