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 Quote 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? Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.