unxposed Posted August 14, 2009 Share Posted August 14, 2009 Hi, Would anybody be able to tell me why I'm getting an error here? Am I not able to use 2 group_concats in the same query? SELECT GROUP_CONCAT(links.title ORDER BY block_links.weight SEPARATOR ', ') AS links, GROUP_CONCAT(links.url ORDER BY block_links.weight SEPARATOR \', \') AS urls FROM blocks LEFT JOIN block_links ON blocks.block_id = block_links.block_id LEFT JOIN links ON block_links.link_id = links.link_id WHERE blocks.block_id IN (4) GROUP BY blocks.block_id Thanks in advance Link to comment https://forums.phpfreaks.com/topic/170260-multiple-group_concats-in-single-select-query/ Share on other sites More sharing options...
fenway Posted August 21, 2009 Share Posted August 21, 2009 What error? Link to comment https://forums.phpfreaks.com/topic/170260-multiple-group_concats-in-single-select-query/#findComment-903199 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.