Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix W228BE 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 = 'WINSTON SALEM' and State = 'NC'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754172238.3676
End: 1754172238.3678
Elapsed time: 0.1650 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NC','Winston Salem',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80093" ["State"]=> string(2) "NC" ["CityName"]=> string(13) "Winston Salem" ["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) "27107" ["zip3"]=> string(3) "271" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(13) "WINSTON SALEM" ["zipstate"]=> string(2) "NC" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(4) "36.1" ["iplongitude"]=> string(6) "-80.24" ["ziplocation"]=> string(22) "NA-US-NC-WINSTON SALEM" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "19196" ["zippopulation"]=> string(5) "35465" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "271" ["zipcity"]=> string(13) "WINSTON SALEM" ["zipstate"]=> string(2) "NC" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "80093" ["State"]=> string(2) "NC" ["CityName"]=> string(13) "Winston Salem" ["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 }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
8 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
27107WINSTON SALEMNC35465Winston Salem
27106WINSTON SALEMNC34137Winston Salem
27105WINSTON SALEMNC27361Winston Salem
27103WINSTON SALEMNC27102Winston Salem
27127WINSTON SALEMNC26600Winston Salem
27104WINSTON SALEMNC24341Winston Salem
27101WINSTON SALEMNC12629Winston Salem
27109WINSTON SALEMNC0Winston Salem
Station W228BE-FX
City WINSTON SALEM-NC

City Winston Salem, NC is located in DMAID: