I have MySQL Table
id | date | name | files |
---|---|---|---|
1 | 2021-10-11 12:00:00 | OG Loc | God Rap |
2 | 2021-10-11 12:00:00 | Ryder | God Weedo |
3 | 2021-10-10 12:00:00 | Carl | God Child |
4 | 2021-10-10 12:00:00 | Johnson | God Cheat |
5 | 2021-10-10 12:00:00 | Big Smoke | God Crackzz |
6 | 2021-10-9 12:00:00 | Sweet | God Brother |
What i want to archive is, the data printed with PHP on table and separated / grouped by date:
# | Ticket(id) | Date | Name | Files |
---|---|---|---|---|
2021-10-11 | ||||
1 | 1 | 2021-10-11 12:00:00 | OG Loc | God Rap |
2 | 2 | 2021-10-11 12:00:00 | Ryder | God Weedo |
2021-10-10 | ||||
3 | 3 | 2021-10-10 12:00:00 | Carl | God Child |
4 | 4 | 2021-10-10 12:00:00 | Johnson | God Cheat |
5 | 5 | 2021-10-10 12:00:00 | Big Smoke | God Crackzz |
2021-10-09 | ||||
6 | 6 | 2021-10-9 12:00:00 | Sweet | God Brother |