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


Number of rows returned = 0
Start: 1754192230.6615
End: 1754192230.6619
Elapsed time: 0.3481 ms No Rows in Recordset!

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

*** city ***************
array(22) { ["id"]=> string(5) "80342" ["State"]=> string(2) "TX" ["CityName"]=> string(8) "Ellinger" ["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) "78938" ["zip3"]=> string(3) "789" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(8) "ELLINGER" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "29.83" ["iplongitude"]=> string(5) "-96.7" ["ziplocation"]=> string(17) "NA-US-TX-ELLINGER" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "789" ["zipcity"]=> string(9) "LA GRANGE" ["zipstate"]=> string(2) "TX" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "19407" ["State"]=> string(2) "TX" ["CityName"]=> string(9) "La Grange" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "29" ["Population"]=> string(4) "3951" ["Latitude"]=> string(9) "29.908262" ["Longitude"]=> string(10) "-96.875025" ["PrimaryAC"]=> string(3) "979" ["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) "19407" ["Population2000"]=> string(4) "4478" ["FIPS"]=> string(7) "4840276" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
24 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
78945LA GRANGETX8215La Grange
78942GIDDINGSTX7076Giddings
78957SMITHVILLETX6612Smithville
78934COLUMBUSTX5742Columbus
78956SCHULENBURGTX4294Schulenburg
78962WEIMARTX3718Weimar
78947LEXINGTONTX3544Lexington
78941FLATONIATX2294Flatonia
78950NEW ULMTX1685New Ulm
78940FAYETTEVILLETX1615Fayetteville
zipcodezipcityzipstatezippopulationcitynameDMAID
78959WAELDERTX1267Waelder
78933CAT SPRINGTX1201
78954ROUND TOPTX889Round Top
78953ROSANKYTX865
78946LEDBETTERTX721
78948LINCOLNTX711
78935ALLEYTONTX689
78963WEST POINTTX655
78932CARMINETX588Carmine
78944INDUSTRYTX555Industry
zipcodezipcityzipstatezippopulationcitynameDMAID
78931BLEIBLERVILLETX0
78943GLIDDENTX0
78938ELLINGERTX0Ellinger
78949MULDOONTX0
Station KTIM-FM
City ELLINGER-TX

City Ellinger, TX is located in DMAID: