Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix KACX 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 = 'LUDLOW' and State = 'CA'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const4Using where


Number of rows returned = 0
Start: 1754151801.6744
End: 1754151801.6748
Elapsed time: 0.3331 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('CA','Ludlow',-1)

*** city ***************
array(22) { ["id"]=> string(5) "79914" ["State"]=> string(2) "CA" ["CityName"]=> string(6) "Ludlow" ["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) "92338" ["zip3"]=> string(3) "923" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "LUDLOW" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "34.72" ["iplongitude"]=> string(7) "-116.15" ["ziplocation"]=> string(15) "NA-US-CA-LUDLOW" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(1) "0" ["zippopulation"]=> string(1) "0" ["zipincome"]=> string(1) "0" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "923" ["zipcity"]=> string(7) "FONTANA" ["zipstate"]=> string(2) "CA" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "1944" ["State"]=> string(2) "CA" ["CityName"]=> string(7) "Fontana" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "219" ["Population"]=> string(5) "87535" ["Latitude"]=> string(9) "34.097744" ["Longitude"]=> string(11) "-117.458222" ["PrimaryAC"]=> string(3) "909" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "1" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "1944" ["Population2000"]=> string(6) "128929" ["FIPS"]=> string(6) "624680" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
47 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
92336FONTANACA66178Fontana
92335FONTANACA65832Fontana
92376RIALTOCA55471Rialto
92345HESPERIACA52569Hesperia127
92346HIGHLANDCA40992Highland
92324COLTONCA40776Colton
92399YUCAIPACA39430Yucaipa
92392VICTORVILLECA37842Victorville127
92374REDLANDSCA29406Redlands27
92307APPLE VALLEYCA28280Apple Valley127
zipcodezipcityzipstatezippopulationcitynameDMAID
92337FONTANACA27988Fontana
92395VICTORVILLECA26559Victorville127
92373REDLANDSCA26330Redlands27
92308APPLE VALLEYCA26211Apple Valley127
92316BLOOMINGTONCA22380Bloomington
92311BARSTOWCA21613Barstow127
92301ADELANTOCA18944Adelanto
92394VICTORVILLECA18928Victorville127
92377RIALTOCA16892Rialto
92354LOMA LINDACA15275Loma Linda
zipcodezipcityzipstatezippopulationcitynameDMAID
92344HESPERIACA13963Hesperia127
92313GRAND TERRACECA9454Grand Terrace
92315BIG BEAR LAKECA6550Big Bear Lake127
92371PHELANCA6321Phelan
92359MENTONECA6159Mentone
92314BIG BEAR CITYCA6104Big Bear City
92310FORT IRWINCA6090Fort Irwin
92320CALIMESACA6035Calimesa
92342HELENDALECA4734Helendale
92397WRIGHTWOODCA4357Wrightwood
zipcodezipcityzipstatezippopulationcitynameDMAID
92356LUCERNE VALLEYCA3770Lucerne Valley127
92372PINON HILLSCA3747
92363NEEDLESCA3538Needles
92365NEWBERRY SPRINGSCA1494
92347HINKLEYCA996Hinkley
92339FOREST FALLSCA792
92358LYTLE CREEKCA603
92309BAKERCA597Baker
92368ORO GRANDECA552
92305ANGELUS OAKSCA521
zipcodezipcityzipstatezippopulationcitynameDMAID
92327DAGGETTCA457Daggett
92364NIPTONCA0
92366MOUNTAIN PASSCA0Mountain Pass
92323CIMACA0Cima
92328DEATH VALLEYCA0Death Valley
92332ESSEXCA0Essex
92338LUDLOWCA0Ludlow
***** 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 KACX-FM
City LUDLOW-CA

City Ludlow, CA is located in DMAID: