
Originariamente inviata da
optime
SET SESSION group_concat_max_len = 1000000;
Esatto cosi Funziona. Grazie 1000
Invece trovo anomalia in :
Codice PHP:
SELECT
CASE WHEN WEEKDAY(calendar.start) = 0 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS Lunedi,
CASE WHEN WEEKDAY(calendar.start) = 1 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS Martedi,
CASE WHEN WEEKDAY(calendar.start) = 2 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS Mercoledi,
CASE WHEN WEEKDAY(calendar.start) = 3 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS Giovedi,
CASE WHEN WEEKDAY(calendar.start) = 4 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS Venerdi,
CASE WHEN WEEKDAY(calendar.start) = 5 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS Sabato,
CASE WHEN WEEKDAY(calendar.start) = 6 THEN CONCAT('[',GROUP_CONCAT(json_object('start',calendar.start)),']') END AS Domenica
FROM calendar
WHERE WEEK(calendar.start) = 16 AND YEAR(calendar.start) = 2021
come result ho
Lunedi 19-04-2021
Martedi 20-04-2021
Mercoledi 21-04-2021
Giovedi 22-04-2021
Venerdi 23-04-2021
Sabato 24-04-2021
Domenica 18-04-2021
Gradirei Domenica 25-04-2021.