Im trying to create a graph that displays count of post per day and display it on the search result page.

Search Example.

1. User searches with the search term "football".
2. The search result page shows a date based line graph such as this: / and a list below the graph with all the posts. (the graph uses json)

Im thinking something in the line of getting all post with the specific search term and then group them by date and then convert that to json.

Example: { "date": "2012-08-04", "value": 20 }

Any suggestions on how to approach this?