Timetable Stats PHP Page

[david759]

I have a field called \[code\]dPostTime\[/code\], which has the date and time stored of an entry. If I wanted to create a page that showed me the number of entries per hour, would I need to have 24 queries, one for each hour, or what's the best way to do this.I'd like the chart to appear as follows:\[code\]5-6pm - 24 posts6-7pm - 56 posts7-8pm - 34 posts8-9pm - 35 posts\[/code\]etc......