how to select the distinct values

[eluser]Bigil Michael[/eluser]
I want to list the members who have products. Query i have written is given below

Code:

$this->db->select('c.*, m.*, cc.category_name, cs.subcategory_name,  css.sub_subcategory_name');
     $this->db->from('classifieds AS c');
  $this->db->join('classi_sub_subcategory AS css', 'css.sub_subcategory_id = c.sub_subcategory_id');
  $this->db->join('classi_subcategory AS cs', 'cs.subcategory_id = css.subcategory_id');
  $this->db->join('classifieds_category AS cc', 'cc.category_id = cs.category_id');
  $this->db->join('members AS m', 'm.id = c.member_id');
  $this->db->where('c.status', 1);
  
     $result_product = $this->db->get();
  return $result_product->result();

It is running fine but member details are repeating. i want to print the member details name only once.
can any one help me????
thanks in advance....