I want to find the next things in the vicinity.
I have a radius in KM. For some of the data, there are no correct results for lat and long based on the radius.
$ lat = 53.2734; $ long = -7,778320; $ radius = 5; $ where = & # 39; ACOS (SIN (field_latitude * 0.0175) & # 39; , # * SIN (: lat * 0.0175) + COS (field_latitude * 0.0175) & # 39; , # * COS (: lat * 0.0175) * COS ((: long * 0.0175) - (field length * 0.0175)) & # 39; , & # 39;) * 6371 <= :radius'; $query->where ($ wo, [ ':lat' => $lat, ':long' => $long, ':radius' => $radius, ]); $ results = $ query-> execute ();
So I have a query for DB above, but for some lat and long there are no correct results.
Can be output with lat, long calculation based on the radius?