Welcome Guest, Not a member yet? Register   Sign In
MySQL - Issue with SELECT & GROUP BY [SOLVED]
#4

(This post was last modified: 11-29-2018, 07:30 AM by Pertti.)

Ah right, I see what's happened here, I thought I copied your original statement, basically it always uses tags_name as string... just pop off the quotes and it should work hopefully. Also you can add AS to name it nicer

PHP Code:
$this->db->select("pages.*,GROUP_CONCAT(tags_name) AS alltags");
...
echo 
$row->alltags// instead of $row->{"GROUP_CONCAT('tags_name')"} 
Reply


Messages In This Thread
RE: MySQL - Issue with SELECT & GROUP BY - by Pertti - 11-29-2018, 07:29 AM



Theme © iAndrew 2016 - Forum software by © MyBB