//get data
$sql = "SELECT id,name, lat, lng, photo, telp, description, open_hour, address, (6371 * acos(cos(radians({$lat})) * cos(radians(lat)) ".
    "* cos(radians(lng) - radians({$lng})) + sin(radians({$lat})) * sin(radians(lat)))) AS distance ".
    " FROM store ".
    " HAVING distance <= 5 ".
    " ORDER BY distance ";