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 = 'FISHER' and State = 'WV'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const4Using where


Number of rows returned = 1
Start: 1754185376.0462
End: 1754185376.0464
Elapsed time: 0.1729 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
79853WVFisher-10

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "26818" ["zip3"]=> string(3) "268" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "FISHER" ["zipstate"]=> string(2) "WV" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "39.05" ["iplongitude"]=> string(3) "-79" ["ziplocation"]=> string(15) "NA-US-WV-FISHER" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "292" ["zippopulation"]=> string(3) "557" ["zipincome"]=> string(7) "7739982" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "268" ["zipcity"]=> string(10) "PETERSBURG" ["zipstate"]=> string(2) "WV" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "21789" ["State"]=> string(2) "WV" ["CityName"]=> string(10) "Petersburg" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "3" ["Population"]=> string(4) "2360" ["Latitude"]=> string(9) "38.993339" ["Longitude"]=> string(10) "-79.126582" ["PrimaryAC"]=> string(3) "304" ["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) "21789" ["Population2000"]=> string(4) "2423" ["FIPS"]=> string(7) "5462956" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
22 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
26847PETERSBURGWV5316Petersburg
26836MOOREFIELDWV5149Moorefield
26807FRANKLINWV2493Franklin
26833MAYSVILLEWV1715Maysville
26851WARDENSVILLEWV1688Wardensville
26812MATHIASWV1314
26801BAKERWV933
26802BRANDYWINEWV891Brandywine
26815SUGAR GROVEWV772
26866UPPER TRACTWV725
zipcodezipcityzipstatezippopulationcitynameDMAID
26845OLD FIELDSWV724
26808HIGH VIEWWV721
26852PURGITSVILLEWV669
26855CABINSWV590
26818FISHERWV557Fisher
26817BLOOMERYWV504
26804CIRCLEVILLEWV488
26810LOST CITYWV0
26838MILAMWV0
26814RIVERTONWV0Riverton
zipcodezipcityzipstatezippopulationcitynameDMAID
26884SENECA ROCKSWV0
26865YELLOW SPRINGWV0
Station WELD-AM
City FISHER-WV

City , is located in DMAID: