Fix WYAB FM Station DMA

Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WYAB FM Station DMA

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 = 'POCAHONTAS' and State = 'MS'

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

Number of rows returned = 0
Start: 1754169175.886
End: 1754169175.8862
Elapsed time: 0.1411 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('MS','Pocahontas',-1)

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

array(22) { ["id"]=> string(5) "80041" ["State"]=> string(2) "MS" ["CityName"]=> string(10) "Pocahontas" ["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) "39072" ["zip3"]=> string(3) "390" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(10) "POCAHONTAS" ["zipstate"]=> string(2) "MS" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "32.41" ["iplongitude"]=> string(6) "-90.22" ["ziplocation"]=> string(19) "NA-US-MS-POCAHONTAS" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }

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

array(3) { ["zip3"]=> string(3) "390" ["zipcity"]=> string(7) "BRANDON" ["zipstate"]=> string(2) "MS" }

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

array(22) { ["id"]=> string(5) "10428" ["State"]=> string(2) "MS" ["CityName"]=> string(7) "Brandon" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "112" ["Population"]=> string(5) "11077" ["Latitude"]=> string(8) "32.28033" ["Longitude"]=> string(9) "-89.99847" ["PrimaryAC"]=> string(3) "601" ["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) "10428" ["Population2000"]=> string(5) "16436" ["FIPS"]=> string(7) "2808300" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "122" }

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

No Rows in Recordset!

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

29 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
10507	MS	Jackson	0	199	196637	32.320445	-90.204415	601		0		0	0	0	0	10507	184256	2836000	-6	-1	122
10633	MS	Vicksburg	0	171	20908	32.335986	-90.875356	601		0		0	0	0	0	10633	26407	2876720	-6	-1	122
37340	MS	Pearl	-1	0	19588	32.271979	-90.105266			0		0	0	0	0		21961	2855760	-6	-1	122
10550	MS	Natchez	0	192	19460	31.554393	-91.387566	601		0		0	0	0	0	10550	18464	2850440	-6	-1	122
10646	MS	Yazoo City	0	138	12427	32.856458	-90.407379	662		0		0	0	0	0	10646	14550	2881520	-6	-1	122
37352	MS	Ridgeland	-1	0	11714	32.418847	-90.124933			0		0	0	0	0		20173	2862520	-6	-1	122
10428	MS	Brandon	0	112	11077	32.28033	-89.99847	601		0		0	0	0	0	10428	16436	2808300	-6	-1	122
10437	MS	Canton	0	150	10062	32.612015	-90.031638	601		0		0	0	0	0	10437	12911	2811100	-6	-1	122
10527	MS	Madison	-1	85	7471	32.457061	-90.108583	601		0		0	0	0	0	10527	14692	2844520	-6	-1	122
10510	MS	Kosciusko	0	112	6986	33.058108	-89.588301	662		0		0	0	0	0	10510	7372	2838320	-6	-1	122
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8284	ME	Kittery	0	49	5151	43.089738	-70.741148	207		0		0	1	0	0	8284	4884	2337235	-5	-1	122
10474	MS	Forest	0	106	5060	32.363627	-89.475348	601		0		0	0	0	0	10474	5987	2825340	-6	-1	122
10491	MS	Hazlehurst	0	84	4221	31.86491	-90.391353	601		0		0	0	0	0	10491	4400	2831220	-6	-1	122
10439	MS	Carthage	0	94	3819	32.741504	-89.535134	601		0		0	0	0	0	10439	4637	2811780	-6	-1	122
10528	MS	Magee	0	75	3607	31.872684	-89.733699	601		0		0	0	0	0	10528	4200	2844600	-6	-1	122
37298	MS	Flowood	-1	0	2860	32.316673	-90.114858			0		0	0	0	0		4750	2825100	-6	-1	122
10463	MS	Durant	-1	1	2838	33.076313	-89.856405	662		0		0	0	0	0	10463	2932	2820500	-6	-1	122
10421	MS	Belzoni	0	61	2536	33.181324	-90.485663	662		0		0	0	0	0	10421	2663	2805140	-6	-1	122
10583	MS	Raymond	0	72	2275	32.258219	-90.41552	601		0		0	0	0	0	10583	1664	2861160	-6	-1	122
10516	MS	Lexington	0	54	2227	33.114329	-90.051191	662		0		0	0	0	0	10516	2025	2840600	-6	-1	122
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
10617	MS	Tchula	-1	1	2186	33.180711	-90.222588	662		0		0	0	0	0	10617	2332	2872440	-6	-1	122
10471	MS	Fayette	0	56	1853	31.711144	-91.062246	601		0		0	0	0	0	10471	2242	2824500	-6	-1	122
10575	MS	Port Gibson	0	82	1810	31.956243	-90.983124	601		0		0	0	0	0	10575	1840	2859560	-6	-1	122
10472	MS	Flora	-1	58	1482	32.543056	-90.311843	601		0		0	0	0	0	10472	1546	2824940	-6	-1	122
10571	MS	Pickens	-1	46	1285	32.886672	-89.970092	662		0		0	0	0	0	10571	1325	2857200	-6	-1	122
10628	MS	Utica	-1	54	1033	32.103426	-90.622214	601		0		0	0	0	0	10628	966	2875760	-6	-1	122
10629	MS	Vaiden	0	3	789	33.331591	-89.747002	662		0		0	0	0	0	10629	840	2875880	-6	-1	122
37267	MS	Bentonia	-1	0	390	32.643889	-90.368121			0		0	0	0	0		500	2805380	-6	-1	122
37374	MS	Walnut Grove	-1	0	389	32.595901	-89.458843			0		0	0	0	0		488	2877520	-6	-1	122

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

33 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
39047	BRANDON	MS	28833	Brandon	122
39042	BRANDON	MS	26551	Brandon	122
39056	CLINTON	MS	20758	Clinton
39046	CANTON	MS	20588	Canton	122
39073	FLORENCE	MS	15468	Florence
39051	CARTHAGE	MS	11734	Carthage	122
39074	FOREST	MS	10722	Forest	122
39090	KOSCIUSKO	MS	9789	Kosciusko	122
39059	CRYSTAL SPRINGS	MS	8962	Crystal Springs
39083	HAZLEHURST	MS	7946	Hazlehurst	122
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
39095	LEXINGTON	MS	5211	Lexington	122
39038	BELZONI	MS	4674	Belzoni	122
39071	FLORA	MS	4237	Flora	122
39069	FAYETTE	MS	3899	Fayette	122
39066	EDWARDS	MS	3500	Edwards
39041	BOLTON	MS	2921	Bolton
39094	LENA	MS	2813	Lena
39063	DURANT	MS	2735	Durant	122
39040	BENTONIA	MS	2588	Bentonia	122
39092	LAKE	MS	2446	Lake
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
39044	BRAXTON	MS	2431	Braxton
39039	BENTON	MS	1812
39086	HERMANVILLE	MS	1808	Hermanville
39057	CONEHATTA	MS	1630	Conehatta
39096	LORMAN	MS	1507
39079	GOODMAN	MS	1308	Goodman
39045	CAMDEN	MS	1154
39082	HARRISVILLE	MS	1038
39067	ETHEL	MS	1026	Ethel
39097	LOUISE	MS	631	Louise
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
39078	GEORGETOWN	MS	615	Georgetown
39054	CARY	MS	0	Cary
39088	HOLLY BLUFF	MS	0	Holly Bluff

Station WYAB-FM

City POCAHONTAS-MS

City Pocahontas, MS is located in DMAID: