vendredi 7 août 2015

PHP5.2 pdo sqlite does not support group_concat() in sql query?

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