Fix WVHY FM Station DMA

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

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: 1754200118.7064
End: 1754200118.7067
Elapsed time: 0.2589 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('GA','Axson',-1)

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

array(22) { ["id"]=> string(5) "80383" ["State"]=> string(2) "GA" ["CityName"]=> string(5) "Axson" ["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) "31624" ["zip3"]=> string(3) "316" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(5) "AXSON" ["zipstate"]=> string(2) "GA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "31.27" ["iplongitude"]=> string(6) "-82.73" ["ziplocation"]=> string(14) "NA-US-GA-AXSON" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "459" ["zippopulation"]=> string(3) "908" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "316" ["zipcity"]=> string(8) "VALDOSTA" ["zipstate"]=> string(2) "GA" }

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

array(22) { ["id"]=> string(4) "3698" ["State"]=> string(2) "GA" ["CityName"]=> string(8) "Valdosta" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "227" ["Population"]=> string(5) "39806" ["Latitude"]=> string(9) "30.846661" ["Longitude"]=> string(10) "-83.283101" ["PrimaryAC"]=> string(3) "229" ["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(4) "3698" ["Population2000"]=> string(5) "43724" ["FIPS"]=> string(7) "1378800" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "268" }

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

No Rows in Recordset!

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

14 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
3698	GA	Valdosta	0	227	39806	30.846661	-83.283101	229		0		0	0	0	0	3698	43724	1378800	-5	-1	268
3580	GA	Moultrie	-1	47	14865	31.170188	-83.783601	229		0		0	0	0	0	3580	14387	1353060	-5	-1	268
3685	GA	Tifton	-1	303	14215	31.463418	-83.510065	229		0		0	0	0	0	3685	15060	1376476	-5	-1	268
3620	GA	Quitman	0	0	5292	30.784677	-83.560747	229		0		0	0	0	0	3620	4638	1363224	-5	-1	268
3338	GA	Adel	0	0	5093	31.138466	-83.425944	229		0		0	0	0	0	3338	5307	1300576	-5	-1	268
3583	GA	Nashville	-1	2	4782	31.206868	-83.246692	229		0		0	0	0	0	3583	4697	1354264	-5	-1	268
3193	FL	Madison	-1	58	3345	30.466265	-83.415284	850		0		0	0	0	0	3193	3061	1242425	-5	-1	268
3506	GA	Homerville	-1	1	2560	31.036832	-82.751302	912		0		0	0	0	0	3506	2803	1339748	-5	-1	268
3531	GA	Lakeland	0	92	2467	31.039214	-83.070397	229		0		0	0	0	0	3531	2730	1344592	-5	-1	268
3606	GA	Pearson	-1	1	1714	31.298368	-82.852827	912		0		0	0	0	0	3606	1805	1359808	-5	-1	268
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
3370	GA	Boston	0	0	1395	30.792556	-83.790681	229		0		0	0	0	0	3370	1417	1309460	-5	-1	268
3491	GA	Hahira	0	0	1353	30.990537	-83.371433	229		0		0	0	0	0	3491	1626	1336052	-5	-1	268
3717	GA	Willacoochee	-1	1	1205	31.335175	-83.046381	912		0		0	0	0	0	3717	1434	1382972	-5	-1	268
80322	GA	Statenville	-1																	0	268

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

27 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
31602	VALDOSTA	GA	23173	Valdosta	268
31601	VALDOSTA	GA	20887	Valdosta	268
31605	VALDOSTA	GA	15600	Valdosta	268
31632	HAHIRA	GA	8003	Hahira	268
31620	ADEL	GA	7649	Adel	268
31639	NASHVILLE	GA	7480	Nashville	268
31636	LAKE PARK	GA	7161	Lake Park
31643	QUITMAN	GA	6500	Quitman	268
31635	LAKELAND	GA	4432	Lakeland	268
31634	HOMERVILLE	GA	4010	Homerville	268
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
31642	PEARSON	GA	3525	Pearson	268
31645	RAY CITY	GA	3307	Ray City
31606	VALDOSTA	GA	2981	Valdosta	268
31626	BOSTON	GA	2705	Boston	268
31647	SPARKS	GA	2475	Sparks
31650	WILLACOOCHEE	GA	2220	Willacoochee	268
31637	LENOX	GA	2212	Lenox
31641	NAYLOR	GA	1601	Naylor
31622	ALAPAHA	GA	1493	Alapaha
31624	AXSON	GA	908	Axson
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
31625	BARNEY	GA	857
31638	MORVEN	GA	797	Morven
31629	DIXIE	GA	683
31648	STATENVILLE	GA	662	Statenville	268
31649	STOCKTON	GA	569
31630	DU PONT	GA	0	Du Pont
31631	FARGO	GA	0	Fargo

Station WVHY-FM

City AXSON-GA

City Axson, GA is located in DMAID: