Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WMHH FM Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9999" ["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 = 'CLIFTON PARK' and State = 'NY'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754169022.3923
End: 1754169022.3929
Elapsed time: 0.5510 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NY','Clifton Park',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80032" ["State"]=> string(2) "NY" ["CityName"]=> string(12) "Clifton Park" ["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) "12065" ["zip3"]=> string(3) "120" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(12) "CLIFTON PARK" ["zipstate"]=> string(2) "NY" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "42.85" ["iplongitude"]=> string(5) "-73.8" ["ziplocation"]=> string(21) "NA-US-NY-CLIFTON PARK" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "21459" ["zippopulation"]=> string(5) "37357" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "120" ["zipcity"]=> string(12) "CLIFTON PARK" ["zipstate"]=> string(2) "NY" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "80032" ["State"]=> string(2) "NY" ["CityName"]=> string(12) "Clifton Park" ["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 **************
63 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
12065CLIFTON PARKNY37357Clifton Park
12020BALLSTON SPANY26539Ballston Spa62
12010AMSTERDAMNY22566Amsterdam62
12078GLOVERSVILLENY17802Gloversville
12054DELMARNY15544Delmar
12047COHOESNY15353Cohoes
12019BALLSTON LAKENY13129
12095JOHNSTOWNNY9856Johnstown
12061EAST GREENBUSHNY8215East Greenbush
12033CASTLETON ON HUDSONNY6953
zipcodezipcityzipstatezippopulationcitynameDMAID
12018AVERILL PARKNY6808Averill Park
12009ALTAMONTNY6187Altamont62
12077GLENMONTNY5577
12043COBLESKILLNY5489Cobleskill159
12025BROADALBINNY4771Broadalbin
12090HOOSICK FALLSNY4771Hoosick Falls
12053DELANSONNY3842Delanson
12027BURNT HILLSNY3731Burnt Hills
12084GUILDERLANDNY3678
12083GREENVILLENY3257Greenville
zipcodezipcityzipstatezippopulationcitynameDMAID
12037CHATHAMNY3004Chatham
12051COXSACKIENY2955Coxsackie
12015ATHENSNY2840Athens
12075GHENTNY2679Ghent
12074GALWAYNY2603Galway
12068FONDANY2499Fonda
12072FULTONVILLENY2216Fultonville
12056DUANESBURGNY2123Duanesburg
12094JOHNSONVILLENY1984Johnsonville
12066ESPERANCENY1819Esperance
zipcodezipcityzipstatezippopulationcitynameDMAID
12023BERNENY1790Berne
12086HAGAMANNY1715Hagaman
12062EAST NASSAUNY1465East Nassau
12059EAST BERNENY1447
12057EAGLE BRIDGENY1434
12067FEURA BUSHNY1314
12052CROPSEYVILLENY1252
12070FORT JOHNSONNY1214Fort Johnson
12093JEFFERSONNY1210
12058EARLTONNY1194
zipcodezipcityzipstatezippopulationcitynameDMAID
12060EAST CHATHAMNY1167
12087HANNACROIXNY1085
12028BUSKIRKNY1039
12076GILBOANY1012
12092HOWES CAVENY1009
12029CANAANNY903Canaan
12032CAROGA LAKENY878Caroga Lake
12022BERLINNY817Berlin
12035CENTRAL BRIDGENY785Central Bridge
12046COEYMANS HOLLOWNY626
zipcodezipcityzipstatezippopulationcitynameDMAID
12063EAST SCHODACKNY563
12041CLARKSVILLENY511Clarksville
12085GUILDERLAND CENTERNY421
12007ALCOVENY0
12017AUSTERLITZNY0
12024BRAINARDNY0
12031CARLISLENY0
12036CHARLOTTEVILLENY0
12042CLIMAXNY0
12064EAST WORCESTERNY0
zipcodezipcityzipstatezippopulationcitynameDMAID
12071FULTONHAMNY0
12008ALPLAUSNY0
12055DORMANSVILLENY0
Station WMHH-FM
City CLIFTON PARK-NY

City Clifton Park, NY is located in DMAID: