cannot select distinct values using codeigniter

Question

Just want to select distinct values from db using codeigniter but it returns duplicate values. Could you please check what is wrong with my code below:

$this->db->distinct('country');
$this->db->where('id',$id);
$query = $this->db->get('table_name');    

Answer 1

can try like this?

$this->db->distinct();
$this->db->select('country');