[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....