countvotes

[eluser]benfike[/eluser]
Hi!

How can I count the answer for the votes_answers?

votes_votes table structure:
id
ansid - answer id
voteid - the poll id
userid - userid

Code:

function countVotesByAnsId($id){
        $this->db->where('ansid',$id);
        $data = '+';
        $Q = $this->db->get('votes_votes');
        if($Q->num_rows() > 0){
            $data = $Q->num_rows();
        }
        $Q->free_result();
        return $data;
    }

Whats the problem with that code?

Now only count the first Answer, answers.