Json con GROUP_CONCAT

[optime]

forse sul tuo server c'è un'impostazione che fa partire la settimana dalla domenica https://www.w3resource.com/mysql/dat...k-function.php

[max1974]

https://www.w3resource.com/mysql/dat...k-function.php

[COLOR=rgba(0, 0, 0, 0.87)]MySQL WEEK() returns the week number for a given date.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.87)]The argument allows the user to specify whether the week starts on Sunday or Monday and whether the return value should be in the range from 0 to 53 or from 1 to 53. If no argument is included with the function, it returns the default week format.

percio :

 WHERE WEEK(calendar.start,1) = 16 

[/COLOR]

[optime]

funziona?

[max1974]

funziona?

Adesso sembra di si grazie 1000

[optime]

optime!