I am using php with Apache and MySql to store data and generate reports. One report calculates the weekly totals using the SELECT WEEK and GROUP BY functions. However, I need to also show the weekending date for each week of the year shown. I am using Friday as the last day for each week. How can I do this?
