I working on a website codeigniter based. In my database i have a lot of dates in this format: yyyy-mm-dd hh:mm:ss
What i want is to represent in a graph, all the 12 months, and for each month the total of dates that i have on my database. For now just a graph for 2012, next year ill change it for 2013.
How can i do it? Any ideas?
I searched a lot for javascript graph/tables such as in google api but none of them gave me everything i needed. Also, how can i read from database the dates and "put them" in each month.
Thanks