for history reason I have to use a very old windows server and it's only support php5.2. Now I can't upgrade the php version but I have a script use group_concat();
how could I do that on such a old win2008 machine?
below is the sql:
SELECT hs_service.*,hs_category.title typename,hs_category.id typeid, group_concat(hs_prof.name) aprof FROM hs_service LEFT JOIN hs_category ON hs_category.id=hs_service.type LEFT JOIN hs_serviceprof ON hs_serviceprof.serviceid = hs_service.id LEFT JOIN hs_prof ON hs_prof.id = hs_serviceprof.profid WHERE ( hs_service.id not null ) GROUP BY hs_service.id ORDER BY hs_service.type ASC,hs_service.ord DESC
Aucun commentaire:
Enregistrer un commentaire