Fix WBNB FM Station DMA

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

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: 1754171353.8688
End: 1754171353.8694
Elapsed time: 0.5760 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('AL','Equality',-1)

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

array(22) { ["id"]=> string(5) "80078" ["State"]=> string(2) "AL" ["CityName"]=> string(8) "Equality" ["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) "36026" ["zip3"]=> string(3) "360" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(8) "EQUALITY" ["zipstate"]=> string(2) "AL" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(4) "32.8" ["iplongitude"]=> string(6) "-86.11" ["ziplocation"]=> string(17) "NA-US-AL-EQUALITY" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "478" ["zippopulation"]=> string(3) "869" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "360" ["zipcity"]=> string(10) "PRATTVILLE" ["zipstate"]=> string(2) "AL" }

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

array(22) { ["id"]=> string(3) "802" ["State"]=> string(2) "AL" ["CityName"]=> string(10) "Prattville" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "83" ["Population"]=> string(5) "19587" ["Latitude"]=> string(9) "32.459135" ["Longitude"]=> string(10) "-86.451305" ["PrimaryAC"]=> string(3) "251" ["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(3) "802" ["Population2000"]=> string(5) "24303" ["FIPS"]=> string(6) "162328" ["cTZoffset"]=> string(2) "-6" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "151" }

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

No Rows in Recordset!

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

15 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
802	AL	Prattville	-1	83	19587	32.459135	-86.451305	251		0		0	0	0	0	802	24303	162328	-6	-1	151
842	AL	Troy	-1	91	13051	31.80196	-85.967317	251		0		0	0	0	0	842	13935	176920	-6	-1	151
845	AL	Tuskegee	-1	141	12257	32.431506	-85.706781	251		0		0	0	0	0	845	11846	177304	-6	-1	151
695	AL	Greenville	-1	23	7492	31.831273	-86.627567	251		0		0	0	0	0	695	7228	131912	-6	-1	151
32415	AL	Millbrook	-1	0	6050	32.497626	-86.368545			0		0	0	0	0		10386	148712	-6	-1	151
836	AL	Tallassee	-1	3	5112	32.539402	-85.893061	334		0		0	0	0	0	836	4934	174688	-6	-1	151
860	AL	Wetumpka	-1	92	4670	32.540972	-86.207726	251		0		0	0	0	0	860	5726	181720	-6	-1	151
847	AL	Union Springs	-1	0	3975	32.140113	-85.712804	334		0		0	0	0	0	847	3670	177880	-6	-1	151
743	AL	Luverne	-1	0	2555	31.714427	-86.263323	334		0		0	0	0	0	743	2635	144728	-6	-1	151
592	AL	Brantley	-1	1	1015	31.584365	-86.256651	334		0		0	0	0	0	592	920	109016	-6	-1	151
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
32328	AL	Coosada	-1	0	912	32.504197	-86.33412			0		0	0	0	0		1382	117176	-6	-1	151
32472	AL	Shorter	-1	0	461	32.401397	-85.943326			0		0	0	0	0		355	170128	-6	-1	151
688	AL	Goshen	-1	0	302	31.719715	-86.125861	334		0		0	0	0	0	688	300	130880	-6	-1	151
68050	AL	Pike Road		0	0	32.26966	-86.140167			0	0	0	0	0	0	0	310	159760	-6	-1	151
799	AL	Pine Level	-1	0		32.072585	-86.060586	334		0		0	0	0	0	799			-6	-1	151

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

52 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
36067	PRATTVILLE	AL	21193	Prattville	151
36092	WETUMPKA	AL	16686	Wetumpka	151
36066	PRATTVILLE	AL	14600	Prattville	151
36054	MILLBROOK	AL	11793	Millbrook	151
36027	EUFAULA	AL	11678	Eufaula	187
36037	GREENVILLE	AL	10687	Greenville	151
36078	TALLASSEE	AL	10586	Tallassee	151
36022	DEATSVILLE	AL	10267	Deatsville
36081	TROY	AL	10180	Troy	151
36093	WETUMPKA	AL	8743	Wetumpka	151
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
36083	TUSKEGEE	AL	6807	Tuskegee	151
36079	TROY	AL	6165	Troy	151
36064	PIKE ROAD	AL	5618	Pike Road	151
36089	UNION SPRINGS	AL	5391	Union Springs	151
36024	ECLECTIC	AL	4753	Eclectic
36049	LUVERNE	AL	4181	Luverne	151
36010	BRUNDIDGE	AL	3931	Brundidge	193
36025	ELMORE	AL	3358	Elmore
36040	HAYNEVILLE	AL	3358	Hayneville
36043	HOPE HULL	AL	3276
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
36033	GEORGIANA	AL	3062	Georgiana	222
36091	VERBENA	AL	2810
36016	CLAYTON	AL	2556	Clayton
36032	FORT DEPOSIT	AL	2230	Fort Deposit
36009	BRANTLEY	AL	1968	Brantley	151
36088	TUSKEGEE INSTITUTE	AL	1889
36080	TITUS	AL	1839
36051	MARBURY	AL	1822
36075	SHORTER	AL	1779	Shorter	151
36003	AUTAUGAVILLE	AL	1628	Autaugaville
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
36069	RAMER	AL	1585	Ramer
36053	MIDWAY	AL	1561	Midway
36036	GRADY	AL	1552
36035	GOSHEN	AL	1462	Goshen	151
36005	BANKS	AL	1336	Banks
36047	LETOHATCHEE	AL	1321
36028	DOZIER	AL	1239	Dozier
36048	LOUISVILLE	AL	1199	Louisville
36041	HIGHLAND HOME	AL	1141
36006	BILLINGSLEY	AL	1117	Billingsley
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
36042	HONORAVILLE	AL	1093
36046	LAPINE	AL	1083	Lapine
36017	CLIO	AL	1074	Clio
36020	COOSADA	AL	963	Coosada	151
36026	EQUALITY	AL	869	Equality
36029	FITZPATRICK	AL	740
36052	MATHEWS	AL	693
36071	RUTLEDGE	AL	682	Rutledge
36034	GLENWOOD	AL	644	Glenwood
36030	FOREST HOME	AL	0	Forest Home
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
36039	HARDAWAY	AL	0
36013	CECIL	AL	0

Station WBNB-FM

City EQUALITY-AL

City Equality, AL is located in DMAID: