New in codeigniter! poll problem

[eluser]larsjeh[/eluser]
[quote author="benfike" date="1251076276"]Error Number: 1066

Not unique table/alias: 'votes_answers'

SELECT * FROM (`votes_answers`, `votes_answers`) JOIN `votes` ON `votes`.`id` = `votes_answers`.`pid`

update: when I delete that: $this->db->from('votes_answers'); the page work, but again list all answers, not only where vote_id = other vote_id[/quote]

Sry m8 made a mistake with $this->db->get , i think this should work.

Code:

function getAnswers(){
        $data = array();
    $this->db->select('*');
    $this->db->from('vote_answers')
    $this->db->join('vote_question', 'vote_question.vote_id = vote_answers.vote_id');
    $Q = $this->db->get();
        if ($Q-> num_rows() > 0){
            foreach ($Q-> result_array() as $row){
            $data['answer'] = $row['answer'];
        }
        }
        $Q-> free_result();
        return $data;
        //DEBUGGING MKKAAYY :)
        print_r($data);
    }