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


Number of rows returned = 0
Start: 1754185183.4147
End: 1754185183.4149
Elapsed time: 0.2160 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('TX','Guthrie',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80298" ["State"]=> string(2) "TX" ["CityName"]=> string(7) "Guthrie" ["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) "79236" ["zip3"]=> string(3) "792" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(7) "GUTHRIE" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "33.62" ["iplongitude"]=> string(7) "-100.32" ["ziplocation"]=> string(16) "NA-US-TX-GUTHRIE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "792" ["zipcity"]=> string(9) "CHILDRESS" ["zipstate"]=> string(2) "TX" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "19014" ["State"]=> string(2) "TX" ["CityName"]=> string(9) "Childress" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "90" ["Population"]=> string(4) "5055" ["Latitude"]=> string(9) "34.424922" ["Longitude"]=> string(11) "-100.213915" ["PrimaryAC"]=> string(3) "940" ["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) "19014" ["Population2000"]=> string(4) "6778" ["FIPS"]=> string(7) "4814668" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
27 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
79201CHILDRESSTX4543Childress
79235FLOYDADATX3085Floydada
79226CLARENDONTX2424Clarendon
79252QUANAHTX2331Quanah262
79241LOCKNEYTX2012Lockney
79245MEMPHISTX1853Memphis195
79248PADUCAHTX1199Paducah
79250PETERSBURGTX1195Petersburg
79227CROWELLTX1049Crowell
79257SILVERTONTX891Silverton
zipcodezipcityzipstatezippopulationcitynameDMAID
79225CHILLICOTHETX791Chillicothe
79244MATADORTX588Matador
79223CEE VEETX0Cee Vee
79247ODELLTX0Odell
79240LELIA LAKETX0
79229DICKENSTX0Dickens
79230DODSONTX0Dodson
79237HEDLEYTX0Hedley
79239LAKEVIEWTX0Lakeview
79243MCADOOTX0Mcadoo
zipcodezipcityzipstatezippopulationcitynameDMAID
79251QUAILTX0Quail
79255QUITAQUETX0Quitaque
79220AFTONTX0Afton
79256ROARING SPRINGSTX0Roaring Springs
79259TELLTX0
79234FLOMOTTX0Flomot
79261TURKEYTX0Turkey
***** 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 KJAG-FM
City GUTHRIE-TX

City Guthrie, TX is located in DMAID: