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


Number of rows returned = 0
Start: 1754142913.2605
End: 1754142913.2606
Elapsed time: 0.1111 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('MS','Mississippi State',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79856" ["State"]=> string(2) "MS" ["CityName"]=> string(17) "Mississippi State" ["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) "39762" ["zip3"]=> string(3) "397" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(17) "MISSISSIPPI STATE" ["zipstate"]=> string(2) "MS" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "33.45" ["iplongitude"]=> string(6) "-88.79" ["ziplocation"]=> string(26) "NA-US-MS-MISSISSIPPI STATE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "557" ["zippopulation"]=> string(3) "849" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "397" ["zipcity"]=> string(8) "COLUMBUS" ["zipstate"]=> string(2) "MS" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "10450" ["State"]=> string(2) "MS" ["CityName"]=> string(8) "Columbus" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "174" ["Population"]=> string(5) "23799" ["Latitude"]=> string(8) "33.50175" ["Longitude"]=> string(10) "-88.415128" ["PrimaryAC"]=> string(3) "662" ["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) "10450" ["Population2000"]=> string(5) "25944" ["FIPS"]=> string(7) "2815380" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "189" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
29 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
10623MSTupelo02133068534.259585-88.7258856620000010623342112874840-6-1189
10450MSColumbus01742379933.50175-88.4151286620000010450259442815380-6-1189
10609MSStarkville01641845833.462471-88.819996620000010609218692870240-6-1189
10453MSCorinth0991182034.937228-88.5152616620000010453140542815700-6-1189
10564MSOxford0151998434.359837-89.5262426620000010564117562854840-6-1189
10642MSWest Point065848933.606155-88.6523696620000010642121452879120-6-1189
10427MSBooneville0102795534.661115-88.561426662000001042786252807780-6-1189
10410MSAmory-1111709333.987283-88.483936662000001041069562801260-6-1189
10408MSAberdeen070683733.824412-88.549733662000001040864152800180-6-1189
10553MSNew Albany0119677534.492237-89.009448662000001055376072851000-6-1189
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
10586MSRipley0115537134.732363-88.947055662000001058654782862600-6-1189
659ALFayette-145490933.692068-87.832358205000006594922125840-6-1189
10573MSPontotoc0109457034.248611-89.006729662000001057352532859160-6-1189
10500MSHouston0115390333.89809-89.001646662000001050040792833900-6-1189
10476MSFulton-10338734.26611-88.401358662000001047638822826300-6-1189
10561MSOkolona052326734.005735-88.750584662000001056130562853680-6-1189
10414MSBaldwyn-137320434.508943-88.639436662000001041433212802700-6-1189
10506MSIuka0111312234.810633-88.195759662000001050630592835300-6-1189
10431MSBruce-10212733.991971-89.342197662000001043120972809180-6-1189
37354MSSaltillo-10178234.373053-88.6894460000033932864840-6-1189
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
10409MSAckerman-11157333.3114-89.174745662000001040916962800300-6-1189
603ALCarrollton-10117033.260858-88.09445220500000603987112304-6-1189
37274MSBrooksville-10109833.232853-88.58160000011822808980-6-1189
10433MSBurnsville-1094934.838564-88.314098662000001043310342809820-6-1189
10631MSVardaman-1092033.879834-89.176929662000001063110652876320-6-1189
18658TNMiddleton-15053635.058798-88.89172873100000186586024748340-1189
37359MSSherman-1052834.360659-88.838734000005482867200-6-1189
10411MSArtesia-1048433.416077-88.64524966200000104114982802100-6-1189
37348MSPotts Camp-1048334.647997-89.304598000004942859720-6-1189
**** cities in zip3 **************
27 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
39759STARKVILLEMS24708Starkville189
39702COLUMBUSMS16834Columbus189
39773WEST POINTMS12412West Point189
39705COLUMBUSMS11121Columbus189
39701COLUMBUSMS9383Columbus189
39730ABERDEENMS8894Aberdeen189
39744EUPORAMS4472Eupora271
39740CALEDONIAMS4013Caledonia
39735ACKERMANMS2986Ackerman189
39746HAMILTONMS2549Hamilton
zipcodezipcityzipstatezippopulationcitynameDMAID
39739BROOKSVILLEMS2385Brooksville189
39750MABENMS2204Maben
39766STEENSMS2097
39752MATHISTONMS1857Mathiston
39743CRAWFORDMS1616Crawford
39756PRAIRIEMS1593
39769STURGISMS1386Sturgis
39747KILMICHAELMS1378Kilmichael
39772WEIRMS1351Weir
39776WOODLANDMS1325Woodland
zipcodezipcityzipstatezippopulationcitynameDMAID
39741CEDARBLUFFMS1188
39751MANTEEMS1045Mantee
39755PHEBAMS823
39745FRENCH CAMPMS659French Camp
39767STEWARTMS587
39737BELLEFONTAINEMS0
39771WALTHALLMS0Walthall
***** stations in DMA*************
29 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
22706GCN2World Wide WebWW79841
41480GCN3World Wide WebWW79841
41481GCN4World Wide WebWW79841
77684GCN5World Wide WebWW79841
32729MOYLWorld Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
44298NPRWorld Wide WebWW79841
44299PRIWorld Wide WebWW79841
22707Radio AmericaWorld Wide WebWW79841
44583SportsBylineWorld Wide WebWW79841
23558TalkStarWorld Wide WebWW79841
40372TammyRadioWorld Wide WebWW79841
44584TheBlazeWorld Wide WebWW79841
22714USA/IRN3World Wide WebWW79841
44301YSNWorld Wide WebWW79841
Station WLXD-FM
City MISSISSIPPI STATE-MS

City Mississippi State, MS is located in DMAID: