DEBUGGING
Address: Glendora
Username: honlphoto
Waldo: GeoIP_Location Object
(
[countryCode] => US
[countryName] => United States
[region] => CA
[city] => Glendora
[postalCode] =>
[latitude] => 34.1321
[longitude] => -117.8511
[areaCode] => 626
[dmaCode] => 803
[countryCode3] => USA
)
Geocode:
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: geocode
Filename: search/template_0004.php
Line Number: 193
Lat: 34.1321
Lon: -117.8511
Geo Source:
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: geo_source
Filename: search/template_0004.php
Line Number: 196
Query: SELECT DISTINCT locations.id, locations.location_number, locations.name, locations.street_address, locations.street_address_line2, locations.street_address_line3, locations.city, locations.state_province, locations.zip_postal_code, locations.country, locations.phone, locations.toll_free, locations.fax, locations.email, locations.website_url, locations.contact_name, locations.contact_title, locations.additional_info, locations.custom1, locations.custom2, locations.custom3, locations.custom4, locations.custom5, locations.custom6, locations.image, locations.marker_url, locations.products, locations.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((34.1321 - locations.lat) * pi()/180 / 2), 2) + COS(34.1321 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-117.8511 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance
FROM (locations)
LEFT JOIN accounts ON locations.account_id = accounts.id
WHERE `accounts`.`username` = 'honlphoto'
AND (3956 * 2 * ASIN(SQRT( POWER(SIN((34.1321 - locations.lat) * pi()/180 / 2),2) + COS(34.1321 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-117.8511 - locations.lon) * pi()/180 / 2),2) )) ) <= '500'
ORDER BY distance asc, locations.location_number asc, locations.id asc
LIMIT 50
Total Rows: 20
Rows: Array
(
[0] => stdClass Object
(
[id] => 103516
[location_number] =>
[name] => Powell Camera Shop
[street_address] => 160 West Badillo Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Covina
[state_province] => CA
[zip_postal_code] => 91723
[country] => USA
[phone] => (626) 332-1253
[toll_free] =>
[fax] => (626) 915-4004
[email] => info@powellcamera.com
[website_url] => www.powellcamera.com
[contact_name] =>
[contact_title] =>
[additional_info] => Store Hours
M-F 9:30am-5:30pm
Sat. 9:30am-5pm
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 34.086262
[lon] => -117.891846
[distance] => 3.92968577232345
)
[1] => stdClass Object
(
[id] => 21576
[location_number] =>
[name] => Samy's Camera
[street_address] => 41 E. Walnut St.
[street_address_line2] =>
[street_address_line3] =>
[city] => Pasadena
[state_province] => CA
[zip_postal_code] => 91103
[country] => USA
[phone] => 626-796-3300
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.samys.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 34.149502
[lon] => -118.149551
[distance] => 17.0975762844628
)
[2] => stdClass Object
(
[id] => 46074
[location_number] =>
[name] => Fullerton Cameras
[street_address] => 809 N. Habor Blvd.
[street_address_line2] =>
[street_address_line3] =>
[city] => Fullerton
[state_province] => CA
[zip_postal_code] => 92832-1534
[country] => USA
[phone] => 714-441-2443
[toll_free] =>
[fax] => 714-441-2445
[email] => info@fullertoncameras.com
[website_url] => www.fullertoncameras.com
[contact_name] =>
[contact_title] =>
[additional_info] => Store Hours
M-F 10am-6pm
Sat. 10am-4pm
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 33.878323
[lon] => -117.924362
[distance] => 18.0169009223
)
[3] => stdClass Object
(
[id] => 42789
[location_number] =>
[name] => Calumet
[street_address] => 1430 S. Village Way
[street_address_line2] =>
[street_address_line3] =>
[city] => Santa Ana
[state_province] => CA
[zip_postal_code] => 92705
[country] => USA
[phone] => 714-285-0143
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.calumetphoto.com
[contact_name] =>
[contact_title] =>
[additional_info] => Store Hours
M-F 9 to 6
Sat. 9 to 5:30
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 33.731243
[lon] => -117.835899
[distance] => 27.6909479689135
)
[4] => stdClass Object
(
[id] => 42788
[location_number] =>
[name] => Calumet
[street_address] => 1135 N. Highland Ave.
[street_address_line2] =>
[street_address_line3] =>
[city] => Los Angeles
[state_province] => CA
[zip_postal_code] => 90038
[country] => USA
[phone] => 323-466-1238
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.calumetphoto.com
[contact_name] =>
[contact_title] =>
[additional_info] => Store Hours
M-F 9 to 6
Sat. 9 to 5:30
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 34.091709
[lon] => -118.338821
[distance] => 28.0199720468926
)
[5] => stdClass Object
(
[id] => 255269
[location_number] =>
[name] => Simon's Camera
[street_address] => 1213 N Highland Ave
[street_address_line2] =>
[street_address_line3] =>
[city] => Los Angeles
[state_province] => CA
[zip_postal_code] => 90038
[country] =>
[phone] => (323) 463-8585
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.simons-camera.in-hollywood-ca.com/
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 34.092880
[lon] => -118.339035
[distance] => 28.0240022894428
)
[6] => stdClass Object
(
[id] => 21572
[location_number] =>
[name] => Samy's Camera
[street_address] => 431 S. Fairfax Ave.
[street_address_line2] =>
[street_address_line3] =>
[city] => Los Angeles
[state_province] => CA
[zip_postal_code] => 90036
[country] => USA
[phone] => 323-938-2420
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.samys.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 34.069012
[lon] => -118.361435
[distance] => 29.5008273306352
)
[7] => stdClass Object
(
[id] => 21574
[location_number] =>
[name] => Samy's Camera
[street_address] => 3309b S. Bristol St.
[street_address_line2] =>
[street_address_line3] =>
[city] => Santa Ana
[state_province] => CA
[zip_postal_code] => 92704
[country] => USA
[phone] => 714-557-9400
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.samys.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 33.703045
[lon] => -117.885422
[distance] => 29.6894050184487
)
[8] => stdClass Object
(
[id] => 21573
[location_number] =>
[name] => Samy's Camera
[street_address] => 4411 Sepulveda Blvd.
[street_address_line2] =>
[street_address_line3] =>
[city] => Culver City
[state_province] => CA
[zip_postal_code] => 90320
[country] => USA
[phone] => 310-450-4551
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.samys.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 34.003136
[lon] => -118.407288
[distance] => 33.0340818068425
)
[9] => stdClass Object
(
[id] => 21577
[location_number] =>
[name] => Samy's Camera
[street_address] => 12636 Beatrice Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Los Angeles
[state_province] => CA
[zip_postal_code] => 90066
[country] => USA
[phone] => 310-450-4365
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.samys.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 33.979576
[lon] => -118.416679
[distance] => 34.0238252129145
)
[10] => stdClass Object
(
[id] => 96562
[location_number] =>
[name] => Bel Air Camera
[street_address] => 10925 Kinross Ave.
[street_address_line2] =>
[street_address_line3] =>
[city] => Los Angeles
[state_province] => CA
[zip_postal_code] => 90024
[country] => USA
[phone] => 310-208-5150
[toll_free] => 800-200-4999
[fax] => 310-208-7472
[email] => info@belaircamera.com
[website_url] => www.belaircamera.com
[contact_name] =>
[contact_title] =>
[additional_info] => Store Hours
M-F 9am- 7pm
Sat. 9:30am- 6pm
Sun. Noon- 5pm
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 34.060429
[lon] => -118.446297
[distance] => 34.388905787783
)
[11] => stdClass Object
(
[id] => 21586
[location_number] =>
[name] => Paul's Photo
[street_address] => 23845 S. Hawthorne Blvd.
[street_address_line2] =>
[street_address_line3] =>
[city] => Torrance
[state_province] => CA
[zip_postal_code] => 90505
[country] => USA
[phone] => (310) 375-7014
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.paulsphoto.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 33.807659
[lon] => -118.351761
[distance] => 36.3825050229433
)
[12] => stdClass Object
(
[id] => 42790
[location_number] =>
[name] => Calumet
[street_address] => 830 W. Valley Parkway
[street_address_line2] => Suite 330
[street_address_line3] =>
[city] => Escondido
[state_province] => CA
[zip_postal_code] => 92025
[country] => USA
[phone] => 760-737-6002
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.calumetphoto.com
[contact_name] =>
[contact_title] =>
[additional_info] => Store Hours
M-F 9:30 to 6
Sat. 9 to 5:30
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 33.117580
[lon] => -117.092918
[distance] => 82.502355005844
)
[13] => stdClass Object
(
[id] => 21575
[location_number] =>
[name] => Samy's Camera
[street_address] => 614 Chapala St.
[street_address_line2] =>
[street_address_line3] =>
[city] => Santa Barbara
[state_province] => CA
[zip_postal_code] => 93101
[country] => USA
[phone] => 805-963-7269
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.samys.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 34.417355
[lon] => -119.698128
[distance] => 107.205734257068
)
[14] => stdClass Object
(
[id] => 226091
[location_number] =>
[name] => Henley's Photo
[street_address] => 2000 H Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Bakersfield
[state_province] => CA
[zip_postal_code] => 93301
[country] => USA
[phone] => 661-324-9484
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 35.377430
[lon] => -119.020836
[distance] => 108.609106271069
)
[15] => stdClass Object
(
[id] => 21520
[location_number] =>
[name] => Casey's Camera
[street_address] => 1550 East Tropicana Ave.
[street_address_line2] =>
[street_address_line3] =>
[city] => Las Vegas
[state_province] => NV
[zip_postal_code] => 89119
[country] => USA
[phone] => 702.736.0890
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.caseyscamera.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 36.101452
[lon] => -115.130928
[distance] => 205.143057568091
)
[16] => stdClass Object
(
[id] => 21519
[location_number] =>
[name] => Keeble & Shuchat Photography
[street_address] => 290 California Ave
[street_address_line2] =>
[street_address_line3] =>
[city] => Palo Alto
[state_province] => CA
[zip_postal_code] => 94306
[country] => USA
[phone] => 650-327-8996
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.kspphoto.com
[contact_name] =>
[contact_title] =>
[additional_info] => Store Hours
Mon.-Sat. 9am-5:30pm
Sun. 11am-5:30pm
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 37.427681
[lon] => -122.144051
[distance] => 330.983978730564
)
[17] => stdClass Object
(
[id] => 21571
[location_number] =>
[name] => Photomark
[street_address] => 2202 East McDowell Rd
[street_address_line2] =>
[street_address_line3] =>
[city] => Phoenix
[state_province] => AZ
[zip_postal_code] => 85006
[country] => USA
[phone] => 800.777.6627
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.photomark.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 33.466187
[lon] => -112.034225
[distance] => 336.853295925615
)
[18] => stdClass Object
(
[id] => 46075
[location_number] =>
[name] => Looking Glass Photo
[street_address] => 2848 Telegraph Avenue
[street_address_line2] =>
[street_address_line3] =>
[city] => Berkeley
[state_province] => CA
[zip_postal_code] => 94705
[country] => USA
[phone] => 510-548-6888
[toll_free] =>
[fax] =>
[email] => info@lookingglassphoto.com
[website_url] => www.lookingglassphoto.com
[contact_name] =>
[contact_title] =>
[additional_info] => Store Hours
M-F 9am-8pm
Sat. 10am-6pm
Sun. 11am-5pm
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 37.858707
[lon] => -122.259636
[distance] => 356.074099358622
)
[19] => stdClass Object
(
[id] => 42791
[location_number] =>
[name] => Calumet
[street_address] => 2001 Bryant Street
[street_address_line2] =>
[street_address_line3] =>
[city] => San Francisco
[state_province] => CA
[zip_postal_code] => 94110
[country] => USA
[phone] => 415-643-9275
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.calumetphoto.com
[contact_name] =>
[contact_title] =>
[additional_info] => Store Hours
M-F 8 to 6
Sat. 9 to 5:30
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 37.761551
[lon] => -122.409790
[distance] => 357.29687822882
)
)