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


Number of rows returned = 1
Start: 1754192084.3808
End: 1754192084.3809
Elapsed time: 0.1321 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
38325NMCannon AFB-10331234.398317-103.327854000003832525573510750-7-1

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "88103" ["zip3"]=> string(3) "881" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(10) "CANNON AFB" ["zipstate"]=> string(2) "NM" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "34.38" ["iplongitude"]=> string(7) "-103.31" ["ziplocation"]=> string(19) "NA-US-NM-CANNON AFB" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "881" ["zipcity"]=> string(6) "CLOVIS" ["zipstate"]=> string(2) "NM" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "12792" ["State"]=> string(2) "NM" ["CityName"]=> string(6) "Clovis" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "0" ["Population"]=> string(5) "30954" ["Latitude"]=> string(9) "34.412509" ["Longitude"]=> string(11) "-103.204611" ["PrimaryAC"]=> string(3) "505" ["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(5) "12792" ["Population2000"]=> string(5) "32667" ["FIPS"]=> string(7) "3516420" ["cTZoffset"]=> string(2) "-7" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
19 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
88101CLOVISNM32423Clovis
88130PORTALESNM13035Portales
88119FORT SUMNERNM1519Fort Sumner
88135TEXICONM1298Texico
88124MELROSENM829Melrose
88113CAUSEYNM0Causey
88123LINGONM0
88133SAINT VRAINNM0
88116ELIDANM0Elida
88118FLOYDNM0Floyd
zipcodezipcityzipstatezippopulationcitynameDMAID
88112BROADVIEWNM0Broadview
88120GRADYNM0Grady
88121HOUSENM0House
88125MILNESANDNM0Milnesand
88126PEPNM0
88114CROSSROADSNM0
88132ROGERSNM0
88134TAIBANNM0
88136YESONM0
***** 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 KNKT-FM
City CANNON AFB-NM

City , is located in DMAID: