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


Number of rows returned = 0
Start: 1754168211.7363
End: 1754168211.7365
Elapsed time: 0.1700 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('LA','Amite',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80006" ["State"]=> string(2) "LA" ["CityName"]=> string(5) "Amite" ["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) "70422" ["zip3"]=> string(3) "704" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(5) "AMITE" ["zipstate"]=> string(2) "LA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "30.73" ["iplongitude"]=> string(6) "-90.51" ["ziplocation"]=> string(14) "NA-US-LA-AMITE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "5241" ["zippopulation"]=> string(4) "9632" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "704" ["zipcity"]=> string(7) "SLIDELL" ["zipstate"]=> string(2) "LA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "7461" ["State"]=> string(2) "LA" ["CityName"]=> string(7) "Slidell" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "178" ["Population"]=> string(5) "24124" ["Latitude"]=> string(8) "30.27904" ["Longitude"]=> string(10) "-89.777744" ["PrimaryAC"]=> string(3) "985" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "7461" ["Population2000"]=> string(5) "25695" ["FIPS"]=> string(7) "2270805" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
34 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
70458SLIDELLLA26965Slidell
70433COVINGTONLA24011Covington
70461SLIDELLLA21515Slidell
70454PONCHATOULALA19878Ponchatoula
70448MANDEVILLELA19852Mandeville
70471MANDEVILLELA17415Mandeville
70403HAMMONDLA16918Hammond83
70460SLIDELLLA16334Slidell
70438FRANKLINTONLA13141Franklinton
70427BOGALUSALA12826Bogalusa
zipcodezipcityzipstatezippopulationcitynameDMAID
70435COVINGTONLA12376Covington
70401HAMMONDLA11915Hammond83
70452PEARL RIVERLA10024Pearl River
70422AMITELA9632Amite
70447MADISONVILLELA8502Madisonville
70445LACOMBELA8065Lacombe
70443INDEPENDENCELA7595Independence
70444KENTWOODLA7259Kentwood83
70420ABITA SPRINGSLA6539Abita Springs
70437FOLSOMLA5997Folsom
zipcodezipcityzipstatezippopulationcitynameDMAID
70466TICKFAWLA5302Tickfaw
70446LORANGERLA4580
70462SPRINGFIELDLA4392Springfield
70431BUSHLA4163Bush
70441GREENSBURGLA3865Greensburg
70426ANGIELA3433Angie
70449MAUREPASLA2666Maurepas
70456ROSELANDLA2206Roseland
70450MOUNT HERMONLA1949Mount Hermon
70455ROBERTLA1604
zipcodezipcityzipstatezippopulationcitynameDMAID
70453PINE GROVELA1109
70436FLUKERLA0
70442HUSSERLA0
70421AKERSLA0
***** 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 K247BJ-FX
City AMITE-LA

City Amite, LA is located in DMAID: