Unanswered: Extracting a table of daily work hours
I have a mySQL database which records advice given to clients. After each advice session the advisor enters the time taken and their name in the table ‘advice’ which contains (amongst others) the fields:
advisor (the name of the adviser - for this question assume the advisors are Alan, Brian and Colin)
date (the date of the advice)
howling (the length of time spent giving the advice)
During a day an advisor could give many pieces of advice to different people.
What I want to do is to extract a table where between two dates (entered as form variables start date and enddate) which for each day gives the time spent on advice and the total for the day from all advisors in the format:
Date | Alan | Brian | Colin | Total days hours |
2014-10-5| 6.5 | 7.2 | 4.0 | 17.7 |
2014-10-6| 4.5 | 3.2 | 2.0 | 9.7 |
I have no idea how it go about this so any help greatly appreciated.