Display Information From 2 Mysql Columns

[zwema]

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.

[Barand]

you need a query like this

SELECT due_date, COUNT(*) as total
FROM table
WHERE due_date BETWEEN CURDATE() AND CURDATE() + INTERVAL 21 DAY
GROUP BY due_date

Edited December 25, 2012 by Barand

[zwema]

Barand, thanks.

 

Now i have selected the data using that statement, how do i go about presenting it as a chart of number of jobs per due_date?

[Barand]

There is a link to baaChart in my signature. That should help.

[zwema]

brilliant! thank you.