Fix WWUU FM Station DMA

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

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

Number of rows returned = 0
Start: 1754171101.4458
End: 1754171101.446
Elapsed time: 0.2239 ms No Rows in Recordset!

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

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

array(22) { ["id"]=> string(5) "80072" ["State"]=> string(2) "MS" ["CityName"]=> string(10) "Washington" ["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) "39190" ["zip3"]=> string(3) "391" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(10) "WASHINGTON" ["zipstate"]=> string(2) "MS" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "31.56" ["iplongitude"]=> string(6) "-91.26" ["ziplocation"]=> string(19) "NA-US-MS-WASHINGTON" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "364" ["zippopulation"]=> string(3) "668" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "391" ["zipcity"]=> string(9) "VICKSBURG" ["zipstate"]=> string(2) "MS" }

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

array(22) { ["id"]=> string(5) "10633" ["State"]=> string(2) "MS" ["CityName"]=> string(9) "Vicksburg" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "171" ["Population"]=> string(5) "20908" ["Latitude"]=> string(9) "32.335986" ["Longitude"]=> string(10) "-90.875356" ["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) "10633" ["Population2000"]=> string(5) "26407" ["FIPS"]=> string(7) "2876720" ["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 **************

36 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
39110	MADISON	MS	30789	Madison	122
39180	VICKSBURG	MS	25610	Vicksburg	122
39120	NATCHEZ	MS	20822	Natchez	122
39157	RIDGELAND	MS	18046	Ridgeland	122
39183	VICKSBURG	MS	12027	Vicksburg	122
39194	YAZOO CITY	MS	12017	Yazoo City	122
39170	TERRY	MS	8155	Terry
39111	MAGEE	MS	7398	Magee	122
39117	MORTON	MS	7390	Morton
39114	MENDENHALL	MS	7230	Mendenhall
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
39154	RAYMOND	MS	7133	Raymond	122
39191	WESSON	MS	6048	Wesson
39168	TAYLORSVILLE	MS	5086	Taylorsville	227
39150	PORT GIBSON	MS	4569	Port Gibson	122
39145	PELAHATCHIE	MS	4171	Pelahatchie
39119	MOUNT OLIVE	MS	4137	Mount Olive
39175	UTICA	MS	3952	Utica	122
39153	RALEIGH	MS	2756	Raleigh
39189	WALNUT GROVE	MS	2605	Walnut Grove	122
39169	TCHULA	MS	2222	Tchula	122
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
39146	PICKENS	MS	2195	Pickens	122
39159	ROLLING FORK	MS	2177	Rolling Fork
39160	SALLIS	MS	2102	Sallis
39116	MIZE	MS	1899	Mize
39140	NEWHEBRON	MS	1745	Newhebron
39176	VAIDEN	MS	1530	Vaiden	122
39108	MC COOL	MS	1399
39192	WEST	MS	1261	West
39149	PINOLA	MS	1220
39144	PATTISON	MS	1087
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
39152	PULASKI	MS	945	Pulaski
39179	VAUGHAN	MS	843
39156	REDWOOD	MS	578
39162	SATARTIA	MS	0	Satartia
39166	SILVER CITY	MS	0	Silver City
39173	TINSLEY	MS	0

Station WWUU-FM

City WASHINGTON-MS

City Washington, MS is located in DMAID: