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

(11-29-2018, 07:29 AM)Pertti Wrote: 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')"} 

Thanks a lot ! It works  Heart Heart Heart 
You are the best !  Heart Heart Heart
Reply


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



Theme © iAndrew 2016 - Forum software by © MyBB