DEBUGING
Address: Washington 20007
Username: vermont_village
Lat: 38.9144
Lon: -77.0763
Geo Source:
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: geo_source
Filename: search/template_0004.php
Line Number: 167
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.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((38.9144 - locations.lat) * pi()/180 / 2), 2) + COS(38.9144 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-77.0763 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance
FROM (locations)
LEFT JOIN accounts ON locations.account_id = accounts.id
WHERE `accounts`.`username` = 'vermont_village'
AND (3956 * 2 * ASIN(SQRT( POWER(SIN((38.9144 - locations.lat) * pi()/180 / 2),2) + COS(38.9144 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-77.0763 - locations.lon) * pi()/180 / 2),2) )) ) <= '50'
ORDER BY distance asc, locations.location_number asc, locations.id asc
LIMIT 5
Total Rows: 5
Rows: Array
(
[0] => stdClass Object
(
[id] => 19698
[location_number] =>
[name] => YES ORGANIC MARKET-PENN
[street_address] => 3425 Connecticut Ave. NW
[street_address_line2] =>
[street_address_line3] =>
[city] => Cleveland Park
[state_province] => District of Columbia
[zip_postal_code] => 20008
[country] =>
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 38.935165
[lon] => -77.057755
[distance] => 1.745854767894
)
[1] => stdClass Object
(
[id] => 19699
[location_number] =>
[name] => YES ORGANIC MARKET-PENN
[street_address] => 658 Pennsylvania Ave
[street_address_line2] =>
[street_address_line3] =>
[city] => Washington
[state_province] => District of Columbia
[zip_postal_code] => 20003
[country] =>
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 38.885250
[lon] => -76.996712
[distance] => 4.72653697716569
)
[2] => stdClass Object
(
[id] => 156742
[location_number] =>
[name] => CHEVY CHASE SUPERMARKET
[street_address] => 8531 CONNECTICUT AVE
[street_address_line2] =>
[street_address_line3] =>
[city] => CHEVY CHASE
[state_province] => MD
[zip_postal_code] => 20815-6826
[country] =>
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 38.995712
[lon] => -77.076096
[distance] => 5.61423543239251
)
[3] => stdClass Object
(
[id] => 19321
[location_number] =>
[name] => MOM'S-ROCKVILLE
[street_address] => 11711 B Parklawn Drive
[street_address_line2] =>
[street_address_line3] =>
[city] => Rockville
[state_province] => Maryland
[zip_postal_code] => 20852
[country] =>
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 39.047771
[lon] => -77.101936
[distance] => 9.31089375132099
)
[4] => stdClass Object
(
[id] => 19318
[location_number] =>
[name] => MOM'S-COLLEGE PK
[street_address] => 9827 Rhode Island Ave
[street_address_line2] =>
[street_address_line3] =>
[city] => College Park
[state_province] => Maryland
[zip_postal_code] => 20740
[country] =>
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 39.014107
[lon] => -76.921295
[distance] => 10.8000122168334
)
)