This query returns an array of the 5 closest cities to our l

$pdo = Doctrine_Manager::getInstance()->getCurrentConnection()->getDbh();
$query = "SELECT name, slug,
         ( 3959 * acos( cos( radians(:lat) ) * cos( radians( lat ) )
          * cos( radians( lng ) - radians(:lng) ) + sin( radians(:lat) )
          * sin( radians( lat ) ) ) ) AS distance
        FROM rss_city WHERE (lat <> :lat and lng <> :lng)HAVING distance IS NOT NULL
        ORDER BY distance LIMIT 5";
$stmt = $pdo->prepare($query);
$params = array(
  "lat"   => $lat,
  "lng"   => $lng
);
$stmt->execute($params);
$results = $stmt->fetchAll();