In continuation of my previous question: Get week/month data
I have a MySQL table with
day column of type
position column of type
I need to fetch average position for every week in consideration. (A week is in consideration if there is a row with
day value belonging to this week.)
The fetched data should be an array of two columns:
Here "date" is the first day (Sunday) of the week and "position" is the average position for this week.
The trouble is how to get the first day for a week.