array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9999" ["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 = 'WETHERSFIELD TWNSHP' and State = 'NY'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754151673.9193
End: 1754151673.9195
Elapsed time: 0.2260 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NY','Wethersfield Twnshp',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79904" ["State"]=> string(2) "NY" ["CityName"]=> string(19) "Wethersfield Twnshp" ["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 ************
city WETHERSFIELD TWNSHP has no post office
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
No Rows in Recordset!

Station WLKK-FM
City WETHERSFIELD TWNSHP-NY

City Wethersfield Twnshp, NY is located in DMAID: