This is a part of MySQL query in CodeIgniter and when I am echoing the sub_product it duplicates the same product name.Is there anything I can do to eliminating duplicate data other than using $this->db->order_by();.
Thanks!!! Ann
$this->db->select(array(
'GROUP_CONCAT(tbl_sub_products.sub_product_name SEPARATOR "<th>" ) as sub_product'
));