Selamat sore, mau nanya dikit donk gan.
klo kita mau pake distinct di codeigniter, gimana yah? dan data yang di ambil. data terbaru.
misal ada 2 data yg sama di dalam field hanya berbeda id. tetapi yg di tampilin hanya data dengan id terbaru.

$this->db->select("id_order");

 $this->db->select("comments");

 $this->db->select("cc_payment_status");

 $this->db->select("resi");

 $this->db->select("DATE_FORMAT(decms_order_history.created_on,'%d-%m-%Y / %H:%i:%s') as created_on_fmt",false);

 $this->db->where("created_by",$id_member);

 

 $this->db->order_by("created_on","desc");

 

 $query = $this->db->get('order_history');

 $result = $query->result();

 if(count($result))

 return $result;

 else

 return $result[0]->total;

terima kasih