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


Number of rows returned = 1
Start: 1754177923.1008
End: 1754177923.101
Elapsed time: 0.2742 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
777ALNotasulga-1097932.560821-85.66763133400000777916155440-6-1

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "36866" ["zip3"]=> string(3) "368" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "NOTASULGA" ["zipstate"]=> string(2) "AL" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "32.55" ["iplongitude"]=> string(6) "-85.67" ["ziplocation"]=> string(18) "NA-US-AL-NOTASULGA" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1685" ["zippopulation"]=> string(4) "2985" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "368" ["zipcity"]=> string(11) "PHENIX CITY" ["zipstate"]=> string(2) "AL" }
**** zip3 city**************
array(22) { ["id"]=> string(3) "794" ["State"]=> string(2) "AL" ["CityName"]=> string(11) "Phenix City" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(3) "139" ["Population"]=> string(5) "25312" ["Latitude"]=> string(9) "32.472822" ["Longitude"]=> string(10) "-85.020121" ["PrimaryAC"]=> string(3) "251" ["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(3) "794" ["Population2000"]=> string(5) "28265" ["FIPS"]=> string(6) "159472" ["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
36830AUBURNAL23518Auburn
36801OPELIKAAL15849Opelika
36867PHENIX CITYAL14901Phenix City
36869PHENIX CITYAL14285Phenix City
36804OPELIKAAL13349Opelika
36870PHENIX CITYAL12839Phenix City
36854VALLEYAL11676Valley187
36832AUBURNAL9975Auburn
36863LANETTAL9401Lanett
36877SMITHS STATIONAL9021
zipcodezipcityzipstatezippopulationcitynameDMAID
36853DADEVILLEAL6312Dadeville
36874SALEMAL6131
36862LAFAYETTEAL4851Lafayette
36875SEALEAL3521
36866NOTASULGAAL2985Notasulga
36856FORT MITCHELLAL2939
36861JACKSONS GAPAL2527
36850CAMP HILLAL2168Camp Hill
36852CUSSETAAL1707
36860HURTSBOROAL1321Hurtsboro
zipcodezipcityzipstatezippopulationcitynameDMAID
36879WAVERLYAL1280Waverly187
36855FIVE POINTSAL1099Five Points
36871PITTSVIEWAL849
36858HATCHECHUBBEEAL0
Station W212AP-FX
City NOTASULGA-AL

City , is located in DMAID: