Fix KQBQ FM Station DMA

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9997" ["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 = 'MEYERSVILLE' and State = 'TX'

Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
cities	ref	CityName	CityName	53	const	1	Using where

Number of rows returned = 0
Start: 1754150282.359
End: 1754150282.3598
Elapsed time: 0.8349 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('TX','Meyersville',-1)

*** city ***************

array(22) { ["id"]=> string(5) "79890" ["State"]=> string(2) "TX" ["CityName"]=> string(11) "Meyersville" ["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) "77974" ["zip3"]=> string(3) "779" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(11) "MEYERSVILLE" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "28.92" ["iplongitude"]=> string(5) "-97.3" ["ziplocation"]=> string(20) "NA-US-TX-MEYERSVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }

******* zip3 ***********

array(3) { ["zip3"]=> string(3) "779" ["zipcity"]=> string(8) "VICTORIA" ["zipstate"]=> string(2) "TX" }

**** zip3 city**************

array(22) { ["id"]=> string(5) "19950" ["State"]=> string(2) "TX" ["CityName"]=> string(8) "Victoria" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "207" ["Population"]=> string(5) "55076" ["Latitude"]=> string(9) "28.816866" ["Longitude"]=> string(10) "-96.993462" ["PrimaryAC"]=> string(3) "361" ["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) "19950" ["Population2000"]=> string(5) "60603" ["FIPS"]=> string(7) "4875428" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }

**** cities in DMA per station **************

No Rows in Recordset!

**** cities in zip3 **************

18 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
77901	VICTORIA	TX	30172	Victoria
77904	VICTORIA	TX	20440	Victoria
77979	PORT LAVACA	TX	13405	Port Lavaca
77905	VICTORIA	TX	11396	Victoria
77954	CUERO	TX	7702	Cuero
77995	YOAKUM	TX	7398	Yoakum
77957	EDNA	TX	6623	Edna
77964	HALLETTSVILLE	TX	6372	Hallettsville
77963	GOLIAD	TX	4188	Goliad
77984	SHINER	TX	3524	Shiner
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
77962	GANADO	TX	2870	Ganado
77968	INEZ	TX	2188	Inez
77983	SEADRIFT	TX	1549	Seadrift
77975	MOULTON	TX	1506	Moulton
77971	LOLITA	TX	750	Lolita
77990	TIVOLI	TX	613	Tivoli
77974	MEYERSVILLE	TX	0	Meyersville
77994	WESTHOFF	TX	0	Westhoff

Station KQBQ-FM

City MEYERSVILLE-TX

City Meyersville, TX is located in DMAID: