Concat error in the recordset
I want to merge several columns from my table by calling CONCAT in the recordset. But that doesn't seem to work. I get HTTP error 500. It works without problems in phpMyAdmin.
The query reads:
SELECT CONCAT (Kategorier.KategoriNamn, " " ,DATE_FORMAT(Provning.ProvningDatum, '%Y-%m-%d kl %H:%i'), " " ,Provning.ProvningPlatser, " " , Kategorier.KategoriPrisklass) AS Provning FROM Kategorier LEFT OUTER JOIN Provning ON Kategorier.KategoriID = Provning.ProvningKategoriID
What is the problem?