Group by

[masadi]

How to add query group by field

[ronisaha]

From the Codeigniter documentation

$this->db->group_by()

Permits you to write the GROUP BY portion of your query:

$this->db->group_by("title"); // Produces: GROUP BY title

You can also pass an array of multiple values as well:

$this->db->group_by(array("title", "date"));  // Produces: GROUP BY title, date