Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WCNM FM Station DMA
array(0) { }
*** DMA ***
array(12) { ["odbcts"]=> string(19) "2009-06-13 09:56:14" ["dmarank"]=> string(1) "0" ["dmaID"]=> string(1) "0" ["dmaType"]=> string(1) "C" ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(13) "United States" ["Population25up"]=> string(9) "300000000" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(2) "WW" }
Database: media
SQL: select * from cities where CityName = 'HAZLET' and State = 'NJ'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 0
Start: 1754178084.2912
End: 1754178084.2914
Elapsed time: 0.2010 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NJ','Hazlet',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80218" ["State"]=> string(2) "NJ" ["CityName"]=> string(6) "Hazlet" ["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) "07730" ["zip3"]=> string(3) "077" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "HAZLET" ["zipstate"]=> string(2) "NJ" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "40.42" ["iplongitude"]=> string(6) "-74.17" ["ziplocation"]=> string(15) "NA-US-NJ-HAZLET" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "8551" ["zippopulation"]=> string(5) "15325" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "077" ["zipcity"]=> string(8) "FREEHOLD" ["zipstate"]=> string(2) "NJ" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "12599" ["State"]=> string(2) "NJ" ["CityName"]=> string(8) "Freehold" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "210" ["Population"]=> string(5) "10742" ["Latitude"]=> string(9) "40.260143" ["Longitude"]=> string(10) "-74.275428" ["PrimaryAC"]=> string(3) "732" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "1" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "12599" ["Population2000"]=> string(5) "10976" ["FIPS"]=> string(7) "3425200" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
42 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
07728FREEHOLDNJ46233Freehold
07726ENGLISHTOWNNJ39570Englishtown
07731HOWELLNJ35010
07712ASBURY PARKNJ31680Asbury Park51
07753NEPTUNENJ30970Neptune
07747MATAWANNJ26986Matawan
07748MIDDLETOWNNJ25426Middletown
07740LONG BRANCHNJ20885Long Branch39
07701RED BANKNJ19393Red Bank
07724EATONTOWNNJ18937Eatontown39
zipcodezipcityzipstatezippopulationcitynameDMAID
07719BELMARNJ18512Belmar
07751MORGANVILLENJ18058Morganville
07746MARLBORONJ17313
07735KEYPORTNJ16520Keyport
07733HOLMDELNJ15555Holmdel
07730HAZLETNJ15325Hazlet
07734KEANSBURGNJ10496Keansburg
07722COLTS NECKNJ9440
07760RUMSONNJ8555Rumson
07762SPRING LAKENJ7512Spring Lake
zipcodezipcityzipstatezippopulationcitynameDMAID
07716ATLANTIC HIGHLANDSNJ7144Atlantic Highlands
07727FARMINGDALENJ6073Farmingdale
07755OAKHURSTNJ6022Oakhurst
07764WEST LONG BRANCHNJ5838West Long Branch
07739LITTLE SILVERNJ5587Little Silver
07718BELFORDNJ5572Belford
07738LINCROFTNJ5508Lincroft
07704FAIR HAVENNJ5437Fair Haven
07757OCEANPORTNJ5116Oceanport
07758PORT MONMOUTHNJ4455Port Monmouth
zipcodezipcityzipstatezippopulationcitynameDMAID
07732HIGHLANDSNJ4081Highlands
07737LEONARDONJ3808Leonardo
07720BRADLEY BEACHNJ3588Bradley Beach
07702SHREWSBURYNJ3546Shrewsbury
07750MONMOUTH BEACHNJ3013Monmouth Beach
07721CLIFFWOODNJ2549
07756OCEAN GROVENJ2503Ocean Grove
07717AVON BY THE SEANJ1687
07711ALLENHURSTNJ1496Allenhurst
07723DEALNJ875Deal
zipcodezipcityzipstatezippopulationcitynameDMAID
07703FORT MONMOUTHNJ664
07799EATONTOWNNJ0Eatontown39
***** stations in DMA*************
26 records found!
stationidCallSignLicenseeServicecitynamexStatexcityid
22710BTRNWorld Wide WebWW79841
23163CRN1World Wide WebWW79841
23164CRN2World Wide WebWW79841
23165CRN3World Wide WebWW79841
23166CRN4World Wide WebWW79841
23167CRN5World Wide WebWW79841
23168CRN6World Wide WebWW79841
42585CSPAN1World Wide WebWW79841
42586CSPAN2World Wide WebWW79841
42587CSPAN3World Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
22711ESPNWorld Wide WebWW79841
58943EWTNWorld Wide WebWW79841
22652Fox NewsWorld Wide WebWW79841
22712Fox SportsWorld Wide WebWW79841
41312GCN1World Wide WebWW79841
41481GCN4World Wide WebWW79841
77684GCN5World Wide WebWW79841
32729MOYLWorld Wide WebWW79841
44298NPRWorld Wide WebWW79841
44299PRIWorld Wide WebWW79841
stationidCallSignLicenseeServicecitynamexStatexcityid
22707Radio AmericaWorld Wide WebWW79841
44583SportsBylineWorld Wide WebWW79841
23558TalkStarWorld Wide WebWW79841
40372TammyRadioWorld Wide WebWW79841
44584TheBlazeWorld Wide WebWW79841
44301YSNWorld Wide WebWW79841
Station WCNM-FM
City HAZLET-NJ

City Hazlet, NJ is located in DMAID: