So, i have values in a database that have dates attached to them.
The format is as such
2009-10-01 , 2009-10-08, 2009-10-16, 2009-10-24,
i need to pull these dates by the DAY and then place it into an array in order to put them in a BAR GRAPH....
The table name is "whiteboard" and the field with the date in it is "client_first_draft_date"
More specifically, ALL of the dates will either be on the 1st, 8th, 16th, or 24th of the month.
I'm trying to ADD all of the 1st's then 8th's 16th's and 24th's and place them into this graph..
the graph javascript code for the graph is like this..
var g = new line_graph();
g.add('01', 145);
g.add('08', 0);
g.add('16', 175);
g.add('24', 130);
the FIRST number is the LABEL (DATE) and the SECOND number is the VALUE (how many clients use that date)...
I really don't know how to do this. I need it to be done in PHP not Javascript.. but.. use the javascript inside the php statement to create the desired effect.
can someone please provide code?
The format is as such
2009-10-01 , 2009-10-08, 2009-10-16, 2009-10-24,
i need to pull these dates by the DAY and then place it into an array in order to put them in a BAR GRAPH....
The table name is "whiteboard" and the field with the date in it is "client_first_draft_date"
More specifically, ALL of the dates will either be on the 1st, 8th, 16th, or 24th of the month.
I'm trying to ADD all of the 1st's then 8th's 16th's and 24th's and place them into this graph..
the graph javascript code for the graph is like this..
var g = new line_graph();
g.add('01', 145);
g.add('08', 0);
g.add('16', 175);
g.add('24', 130);
the FIRST number is the LABEL (DATE) and the SECOND number is the VALUE (how many clients use that date)...
I really don't know how to do this. I need it to be done in PHP not Javascript.. but.. use the javascript inside the php statement to create the desired effect.
can someone please provide code?