This doesn't work the way I want it to. I did a simple count of how many files were uploaded within the last hour and the amount I totaled by hand were far less than what the mysql query totaled for me.
Right now it's 10pm EST and my count for 10pm EST is showing 10, but what I get back from the mysql query total is 175, which is far from correct.
SELECT COUNT( file ) AS total, HOUR( FROM_UNIXTIME( `dateTime` ) ) AS `hour`
WHERE `file` != ''
GROUP BY HOUR( FROM_UNIXTIME( `dateTime` ) )
All I really want is a running count on a 24 hour basis of how many files were uploaded like this:
10pm = 10
9pm = 2
8pm = 12
7pm = 22
6pm = 100
5pm = 13
4pm = 23
11pm = 12