Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

Elementary question, Use php to chart jobs by due date

Codes here !

Moderators: macek, egami, gesf

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 ... 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.
New php-forum User
New php-forum User
Posts: 1
Joined: Sun Dec 16, 2012 10:43 pm

Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.