Hello all,
I’m new to PHP-MySQL and I have what may appear to be an elementary question. But please help:
I have 3 MySQL columns 'due_date', 'client' and 'client_number_of_jobs'.
please refer to image on this page
Using PHP, I would like to chart the number of times a due_date appears in the table, the other columns don’t really matter.
Please note that I would also like to display dates on which there are no jobs for example, 13th December 2012, 17th December 2012
The view should start from “today’s date” and end with “today’s date + 21 days” (jobs over the next 3 weeks)
I’ll appreciate your help, thank you.