jQuery flot，MySQL计算每天的行数

Question

I've table for hits that contains of 2 fields

id    time(TIMESTAMP)
1     2012-05-03 08:56:17
2     2012-04-26 03:22:20
3     2012-05-03 08:56:17

How can I count how many rows for each day for example for the past 10 days?

I mean what is the right query for it that produces:

2012-05-03 => 25 hits 2012-05-05 => 55 hits etc

Also, how can i arrange the returned array as jQuery flot array ?

any answers / articles regarding my questions would be great help

Thank you

Answer 1

You want to use a Group By on the date field something like

select count(*), dateField from tablename 
group by dateField