消除MySQL结果中的重复数据

Question

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'
        ));

Answer 1

You should use group_by():

$this->db->select(array(            
            'GROUP_CONCAT(tbl_sub_products.sub_product_name SEPARATOR "<th>") as sub_product'
))->group_by("sub_product_name");

I'm not entirely sure on the name of the product name column, so you will have to change that.