DEBUGING
Address: Washington 20007
Username: Varabella
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` = 'Varabella'
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) )) ) <= '500'
ORDER BY distance asc, locations.location_number asc, locations.id asc
LIMIT 5
Total Rows: 4
Rows: Array
(
[0] => stdClass Object
(
[id] => 42223
[location_number] =>
[name] => Westfield Southpark Mall
[street_address] => 500 Southpark Center
[street_address_line2] =>
[street_address_line3] =>
[city] => Strongsville
[state_province] => OH
[zip_postal_code] => 44136
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] => Martie@mac.com
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] => We carry all the Varabella bags in our Mall Cart
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 41.310249
[lon] => -81.823837
[distance] => 300.278575505226
)
[1] => stdClass Object
(
[id] => 18675
[location_number] =>
[name] => Purse' Purse
[street_address] => 4920 Vines Rd
[street_address_line2] =>
[street_address_line3] =>
[city] => Howell
[state_province] => MI
[zip_postal_code] => 48843
[country] => USA
[phone] => 517-546-8042
[toll_free] =>
[fax] =>
[email] => c_reed@charter.net
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.535439
[lon] => -84.011269
[distance] => 440.430533817941
)
[2] => stdClass Object
(
[id] => 18666
[location_number] =>
[name] => Vets Too Gift Boutique
[street_address] => 2416 Northeast St
[street_address_line2] =>
[street_address_line3] =>
[city] => Lansing
[state_province] => MI
[zip_postal_code] => 48906
[country] => USA
[phone] => 517-267-1860
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 42.759186
[lon] => -84.542816
[distance] => 471.5097729877
)
[3] => stdClass Object
(
[id] => 18674
[location_number] =>
[name] => UpTown Girl
[street_address] => 111 Center Ave
[street_address_line2] =>
[street_address_line3] =>
[city] => Bay City
[state_province] => MI
[zip_postal_code] => 48708
[country] => USA
[phone] => 989-891-0128
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 43.598179
[lon] => -83.889381
[distance] => 478.903968052813
)
)