Here is the table:
tracking_id, project_id, project_time, createdat
Title Line of Report
Totals for 8/10 - 8/14
Project ID | Mon | Tue | Wed | Thu | Fri
Where the day columns are the total from the database for that day for the project
1. Some days might be missing.
2. the date range is dynamic.
Here is what I have so far:
The query returns the results but not in a way I can easily generate an html table.
What I need to know: is their an easy way to rewrite the query so that there is 1 row per project_id and all the totals returned...
or how would I go about writing the PHP to output 1 row per project_id and the totals for the day columns.
Attached is a sample report, but it does not correlate with the data in the fiddle.