ActiveRecord Return Row id

[eluser]chrislorenz[/eluser]
Yeah, I realized that once I started piecing everything together. I worked around it by doing this:

Code:

function get_submissions_rank()
        {

            $resetrank = 'SET @rank := 0';
            $this->db->query($resetrank);
            $query = 'SELECT rank, VoteCount, submission_id FROM (
                        SELECT @rank:=@rank+1 AS rank, s.submission_id
                              , Count( v.submission_id ) AS VoteCount
                        FROM submission AS s
                        LEFT JOIN vote AS v
                              ON v.submission_id = s.submission_id
                        WHERE 1=1
                        GROUP BY s.submission_id
                        ORDER BY rank ASC
                        ) AS t';
            $result = $this->db->query($query);
}

This seems to work but after going through all of this I think I may just end up iterating with a counter.