'SELECT *, ( 6371 * acos( cos( radians(' . $lat . ') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(' . $lng . ') ) + sin( radians(' . $lat .') ) * sin( radians(lat) ) ) ) AS distance FROM users WHERE profileStatus LIKE 'PUBLIC' HAVING distance < ' . $distance
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community