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
https://docs.google.com/document/d/1lYi ... f7-zE/edit
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 for next 3 week)
I’ll appreciate your help, thank you.