Poll Query

[eluser]wowdezign[/eluser]
This should get you one row from the database and return it.

Code:

function displayPoll(){
   $data=array();
   $this->db->order_by('poll.id', 'DESC');
   $this->db->join('options', 'poll.id = options.id_poll');
   $Q=$this->db->get('poll',1); // the 1 sets the limit to 1 record
  
   if($Q->num_rows() >0) {
       return $Q->row();
    }
}

If you want the possible answers, you could run another query using the id to get the answers.