MySQL Problem - Help (Unresolved)

[eluser]markup2go[/eluser]
You would use it in your select. Here's an example of how I did it with a similar database setup:

Code:

$this->db->select("classes.*, GROUP_CONCAT(DISTINCT DATE_FORMAT(class_dates.date, '%m/%d/%Y') ORDER BY date ASC SEPARATOR ',') as dates", FALSE);

So you would do something like

Code:

$this->db->select("post.*, GROUP_CONCAT(DISTINCT tag.tag ORDER BY tag ASC SEPARATOR ',') as tag", FALSE);