GROUP_CONCAT Equivalent
Posted: Tue May 10, 2005 12:05 pm
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.
So what would be an equivalent SELECT statement that would work with MySQL 4.0?
Thanks.
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`");Thanks.