Another query

gistfile1.txt

//this is giving me an array of project_licence id numbers

public function getAssignedProjectLicenceIds() {

    $user_id = $this->getId();

    $connection = Doctrine_Manager::connection();
    $query = 'SELECT
              p.id as ids
              FROM
              project_licence p
              INNER JOIN
              lab l
              ON
              p.lab_id = l.id
              RIGHT OUTER JOIN
              lab_user lu
              ON
              lu.lab_id = l.id
              WHERE
              lu.user_id = ' . $user_id;


    $statement = $connection->execute($query);

    $statement->execute();
    $resultset = $statement->fetchAll(PDO::FETCH_COLUMN, 0);

    return $resultset;
  }