function getNearestProvider($lat, $lng, &$distance) { $provider = null; $rs = $this->db->getResultset("SELECT \t id, distance_km(latitude,longitude," . Database::SqlNumeric($lat) . "," . Database::SqlNumeric($lng) . ") AS distance_km\n FROM \t provider\n WHERE partner_code = 'TREAT'\n AND active = 'T'\n ORDER BY distance_km ASC\n LIMIT \t 1"); if (count($rs) > 0) { $provider = new Provider($rs[0]['id']); $distance = $rs[0]['distance_km']; } return $provider; }