Fix WRVI FM Station DMA

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

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: 1754169025.7053
End: 1754169025.7054
Elapsed time: 0.1678 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('PA','Allport',-1)

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

array(22) { ["id"]=> string(5) "80034" ["State"]=> string(2) "PA" ["CityName"]=> string(7) "Allport" ["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) "16821" ["zip3"]=> string(3) "168" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(7) "ALLPORT" ["zipstate"]=> string(2) "PA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "40.97" ["iplongitude"]=> string(6) "-78.21" ["ziplocation"]=> string(16) "NA-US-PA-ALLPORT" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }

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

array(3) { ["zip3"]=> string(3) "168" ["zipcity"]=> string(13) "STATE COLLEGE" ["zipstate"]=> string(2) "PA" }

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

array(22) { ["id"]=> string(5) "17023" ["State"]=> string(2) "PA" ["CityName"]=> string(13) "State College" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "181" ["Population"]=> string(5) "38923" ["Latitude"]=> string(9) "40.791261" ["Longitude"]=> string(9) "-77.85874" ["PrimaryAC"]=> string(3) "814" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "17023" ["Population2000"]=> string(5) "38420" ["FIPS"]=> string(7) "4273808" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "254" }

**** 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
17023	PA	State College	0	181	38923	40.791261	-77.85874	814		0		0	1	0	0	17023	38420	4273808	-5	-1	254
16670	PA	Lewistown	-1	94	9341	40.597385	-77.573238	717		0		0	1	0	0	16670	8998	4243000	-5	-1	254
16679	PA	Lock Haven	-1	74	9230	41.134388	-77.450347	570		0		0	0	0	0	16679	9149	4244128	-5	-1	254
16403	PA	Clearfield	-1	109	6633	41.022555	-78.440233	814		0		0	1	0	0	16403	6631	4214064	-5	-1	254
16319	PA	Bellefonte	-1	76	6358	40.914684	-77.774756	814		0		0	0	0	0	16319	6395	4205256	-5	-1	254
16618	PA	Jersey Shore	-1	22	4353	41.202587	-77.266715	570		0		0	0	0	0	16618	4482	4238128	-5	-1	254
16885	PA	Philipsburg	-1	76	3048	40.897315	-78.21895	814		0		0	0	0	0	16885	3056	4260008	-5	-1	254
16438	PA	Curwensville	-1	79	2924	40.973408	-78.522318	814		0		0	0	0	0	16438	2650	4217840	-5	-1	254
16769	PA	Mount Union	-1	38	2878	40.384845	-77.88329	814		0		0	0	0	0	16769	2504	4251984	-5	-1	254
16839	PA	Patton	-1	13	2206	40.634466	-78.650812	814		0		0	0	0	0	16839	2023	4258432	-5	-1	254
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
16344	PA	Boalsburg	-1	58	2206	40.78267	-77.786899	814		0		0	0	0	0	16344	3578	4207368	-5	-1	254
16301	PA	Avis	0	18	1506	41.185234	-77.316455	570		0		0	0	0	0	16301	1492	4203632	-5	-1	254
16387	PA	Centre Hall	-1	73	1203	40.844287	-77.684615	814		0		0	0	0	0	16387	1079	4212376	-5	-1	254
16922	PA	Port Matilda	-1	0	669	40.800056	-78.051119	814		0		0	0	0	0		638	4262280	-5	-1	254

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

42 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
16801	STATE COLLEGE	PA	21293	State College	254
16823	BELLEFONTE	PA	19473	Bellefonte	254
16803	STATE COLLEGE	PA	15132	State College	254
16830	CLEARFIELD	PA	10880	Clearfield	254
16866	PHILIPSBURG	PA	6561	Philipsburg	254
16870	PORT MATILDA	PA	6289	Port Matilda	254
16841	HOWARD	PA	4357	Howard
16833	CURWENSVILLE	PA	4315	Curwensville	254
16827	BOALSBURG	PA	3952	Boalsburg	254
16828	CENTRE HALL	PA	3930	Centre Hall	254
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
16875	SPRING MILLS	PA	3258	Spring Mills
16858	MORRISDALE	PA	2991
16844	JULIAN	PA	2236	Julian
16822	BEECH CREEK	PA	1958	Beech Creek
16881	WOODLAND	PA	1828
16838	GRAMPIAN	PA	1628	Grampian
16865	PENNSYLVANIA FURNACE	PA	1593
16878	WEST DECATUR	PA	1583
16877	WARRIORS MARK	PA	1474	Warriors Mark
16874	SNOW SHOE	PA	1099	Snow Shoe
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
16872	REBERSBURG	PA	1026	Rebersburg
16836	FRENCHVILLE	PA	944	Frenchville
16820	AARONSBURG	PA	867	Aaronsburg
16854	MILLHEIM	PA	848	Millheim
16863	OLANTA	PA	651
16829	CLARENCE	PA	597	Clarence
16845	KARTHAUS	PA	593
16802	UNIVERSITY PARK	PA	458
16859	MOSHANNON	PA	431
16821	ALLPORT	PA	0	Allport
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
16864	ORVISTON	PA	0
16832	COBURN	PA	0	Coburn
16850	LECONTES MILLS	PA	0
16840	HAWK RUN	PA	0
16871	POTTERSDALE	PA	0
16852	MADISONBURG	PA	0	Madisonburg
16839	GRASSFLAT	PA	0
16861	NEW MILLPORT	PA	0
16837	GLEN RICHEY	PA	0
16860	MUNSON	PA	0
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
16879	WINBURNE	PA	0	Winburne
16882	WOODWARD	PA	0	Woodward

Station WRVI-FM

City ALLPORT-PA

City Allport, PA is located in DMAID: