bXi
public php v1 · immutable$query = "SELECT *, truncate((degrees(acos(sin(radians(" . $y . ")) * sin( radians(" . 'latitude' . ")) + cos(radians(" . $y . ")) * cos( radians(" . 'latitude' . ")) * cos(radians(" . $x . " - " . 'longitude' . ")))) * 69.09),1) as distance FROM steden ORDER BY `distance` ASC;"