DEBUGGING
Address: Glendora
Username: vjarnold
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` = 'vjarnold'
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) )) ) <= '30'
ORDER BY distance asc, locations.location_number asc, locations.id asc
LIMIT 1
Total Rows: 1
Rows: Array
(
[0] => stdClass Object
(
[id] => 313600
[location_number] => 118
[name] => Proforma Gold Star Promotions
[street_address] => 1240 E. Ontario Ave
[street_address_line2] => Suite#102-349
[street_address_line3] =>
[city] => Corona
[state_province] => CA
[zip_postal_code] => 92881
[country] => United States
[phone] => 951-741-0400
[toll_free] =>
[fax] => 951-272-4473
[email] => therese.marquez@proforma.com
[website_url] =>
[contact_name] => Therese Marquez
[contact_title] =>
[additional_info] => Certified Digital PublishingSpecialist
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[products] =>
[lat] => 33.847187
[lon] => -117.543304
[distance] => 26.4096601225732
)
)