Elementary question, Use php to chart jobs by due date

Codes here !

Moderators: macek, egami, gesf

zwema
New php-forum User
New php-forum User
Posts: 1
Joined: Sun Dec 16, 2012 10:43 pm

Elementary question, Use php to chart jobs by due date

Postby zwema » Mon Dec 17, 2012 3:22 am

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

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.

Return to “mySQL & php coding”

Who is online

Users browsing this forum: Bing [Bot] and 2 guests

cron