Page 1 of 1

GROUP_CONCAT Equivalent

Posted: Tue May 10, 2005 12:05 pm
by DevBear
The following SELECT statement works on my local site, but not on my remote site because my host hasn't upgraded to MySQL 4.1.

Code: Select all

$res = mysql_query("SELECT GROUP_CONCAT(DISTINCT Area SEPARATOR ', ') as Area, Class, ClassCommon, OrderCommon, `Order`
FROM symbols WHERE Class = '$myname' GROUP BY `Order` ORDER BY `Order`");
So what would be an equivalent SELECT statement that would work with MySQL 4.0?

Thanks.