Fix KAGP FM Station DMA

Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix KAGP FM 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 = 'GREENWOOD' and State = 'TX'

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

Number of rows returned = 0
Start: 1754168023.8596
End: 1754168023.8598
Elapsed time: 0.2618 ms No Rows in Recordset!

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

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

array(22) { ["id"]=> string(5) "79993" ["State"]=> string(2) "TX" ["CityName"]=> string(9) "Greenwood" ["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) "76246" ["zip3"]=> string(3) "762" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(9) "GREENWOOD" ["zipstate"]=> string(2) "TX" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "33.38" ["iplongitude"]=> string(6) "-97.47" ["ziplocation"]=> string(18) "NA-US-TX-GREENWOOD" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }

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

array(3) { ["zip3"]=> string(3) "762" ["zipcity"]=> string(6) "DENTON" ["zipstate"]=> string(2) "TX" }

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

array(22) { ["id"]=> string(5) "19102" ["State"]=> string(2) "TX" ["CityName"]=> string(6) "Denton" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "291" ["Population"]=> string(5) "66270" ["Latitude"]=> string(9) "33.216296" ["Longitude"]=> string(10) "-97.129194" ["PrimaryAC"]=> string(3) "940" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "1" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "19102" ["Population2000"]=> string(5) "80537" ["FIPS"]=> string(7) "4819972" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(1) "5" }

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

No Rows in Recordset!

***** cities in DMA by city *************

32 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
19083	TX	Dallas	0	791	1006877	32.799528	-96.787166	214		1		1	1	1	0	19083	1188580	4819000	-6	-1	5
18831	TX	Arlington	0	270	261721	32.705033	-97.122839	817		0		1	0	1	0	18831	332969	4804000	-6	-1	5
19223	TX	Garland	-1	0	180650	32.907325	-96.635197	972		0		0	0	0	0		215768	4829000	-6	-1	5
19252	TX	Grand Prairie	0	200	99616	32.715266	-97.016864	214		0		1	0	1	0	19252	127427	4830464	-6	-1	5
19102	TX	Denton	0	291	66270	33.216296	-97.129194	940		0		1	0	1	0	19102	80537	4819972	-6	-1	5
19440	TX	Lewisville	-1	191	46521	33.038316	-97.006232	972		0		1	1	1	0	19440	77737	4842508	-6	-1	5
41195	TX	Hurst	-1	0	33574	32.835629	-97.180172			0		0	0	0	0		36273	4835576	-6	-1	5
19026	TX	Cleburne	0	221	22205	32.351547	-97.392596	817		0		1	0	1	0	19026	26005	4815364	-6	-1	5
18805	TX	Allen	-1	97	18309	33.099748	-96.662922	972		0		1	0	0	0	18805	43554	4801924	-6	-1	5
41046	TX	Balch Springs	-1	0	17406	32.717381	-96.615154			0		0	0	0	0		19375	4805372	-6	-1	5
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
18967	TX	Burleson	-1	0	16113	32.535939	-97.327257	817		0		0	0	0	0		20976	4811428	-6	-1	5
41148	TX	Flower Mound	-1	0	15527	33.031741	-97.078818			0		0	0	0	0		50702	4826232	-6	-1	5
19547	TX	Mineral Wells	-1	113	14870	32.808594	-98.101859	940		0		0	0	0	0	19547	16946	4848684	-6	-1	5
19968	TX	Weatherford	0	190	14804	32.759238	-97.784997	817		0		1	0	0	0	19968	19000	4876864	-6	-1	5
19215	TX	Gainesville	-1	71	14256	33.63036	-97.140323	940		0		0	0	0	0	19215	15538	4827984	-6	-1	5
19250	TX	Graham	-1	14	8986	33.100778	-98.579254	940		0		0	0	0	0	19250	8716	4830392	-6	-1	5
18851	TX	Azle	-1	5	8868	32.892653	-97.536789	817		0		0	0	1	0	18851	9600	4805168	-6	-1	5
19210	TX	Frisco	0	147	6141	33.141263	-96.81312	817		0		1	0	0	0	19210	33714	4827684	-6	-1	5
18925	TX	Bowie	-1	0	4990	33.560119	-97.844569	940		0		0	0	0	0	18925	5219	4809640	-6	-1	5
19095	TX	Decatur	-1	86	4252	33.231073	-97.588628	940		0		0	0	0	0	19095	5201	4819528	-6	-1	5
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
19251	TX	Granbury	0	167	4045	32.441978	-97.781383	817		0		0	0	0	0	19251	5718	4830416	-6	-1	5
41208	TX	Keene	-1	0	3944	32.39286	-97.327501			0		0	0	0	0		5003	4838548	-6	-1	5
19795	TX	Sanger	-1	0	3508	33.363068	-97.176212	940		0		0	0	0	0	19795	4534	4865408	-6	-1	5
19991	TX	Whitesboro	0	6	3209	33.659612	-96.905999	903		0		0	0	0	0	19991	3760	4878532	-6	-1	5
19665	TX	Pilot Point	0	6	2538	33.39635	-96.958719	940		0		0	0	1	0	19665	3538	4857476	-6	-1	5
19321	TX	Howe	-1	5	2173	33.505089	-96.614239	903		0		0	0	0	0	19321	2478	4835084	-6	-1	5
19236	TX	Glen Rose	-1	0	1949	32.236637	-97.753823	254		0		0	0	1	0	19236	2122	4829876	-6	-1	5
19857	TX	Springtown	-1	113	1740	32.9675	-97.682599	817		0		0	0	1	0	19857	2062	4869800	-6	-1	5
19401	TX	Krum	-1	0	1542	33.264818	-97.235665	940		0		0	0	0	0	19401	1979	4839928	-6	-1	5
19572	TX	Muenster	-1	0	1387	33.650937	-97.375659	940		0		0	0	0	0	19572	1556	4849932	-6	-1	5
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
19942	TX	Valley View	-1	0	640	33.493656	-97.164403	940		0		0	0	0	0	19942	737	4874756	-6	-1	5
69951	TX	Haltom City		0	0	32.816129	-97.271634			0	0	0	0	0	0	0	39018	4831928	-6	-1	5

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

37 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
76248	KELLER	TX	70353	Keller
76210	DENTON	TX	31092	Denton	5
76262	ROANOKE	TX	22173	Roanoke
76240	GAINESVILLE	TX	19357	Gainesville	5
76209	DENTON	TX	17982	Denton	5
76227	AUBREY	TX	17657	Aubrey
76226	ARGYLE	TX	14869	Argyle
76208	DENTON	TX	14705	Denton	5
76234	DECATUR	TX	12732	Decatur	5
76201	DENTON	TX	11718	Denton	5
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
76205	DENTON	TX	11567	Denton	5
76266	SANGER	TX	10870	Sanger	5
76247	JUSTIN	TX	10412	Justin
76207	DENTON	TX	8326	Denton	5
76230	BOWIE	TX	7829	Bowie	5
76273	WHITESBORO	TX	7231	Whitesboro	5
76249	KRUM	TX	6107	Krum	5
76244	KELLER	TX	5891	Keller
76258	PILOT POINT	TX	5348	Pilot Point	5
76255	NOCONA	TX	4295	Nocona
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
76272	VALLEY VIEW	TX	3710	Valley View	5
76259	PONDER	TX	3675	Ponder
76225	ALVORD	TX	2633	Alvord
76233	COLLINSVILLE	TX	2545	Collinsville
76252	MUENSTER	TX	2474	Muenster	5
76265	SAINT JO	TX	1483
76270	SUNSET	TX	1477	Sunset
76245	GORDONVILLE	TX	1406	Gordonville
76264	SADLER	TX	1199	Sadler
76271	TIOGA	TX	1188	Tioga
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
76250	LINDSAY	TX	1081	Lindsay
76228	BELLEVUE	TX	870	Bellevue
76239	FORESTBURG	TX	827	Forestburg
76251	MONTAGUE	TX	632	Montague
76238	ERA	TX	474
76261	RINGGOLD	TX	0	Ringgold
76263	ROSSTON	TX	0	Rosston

Station KAGP-FM

City GREENWOOD-TX

City Greenwood, TX is located in DMAID: