I have a site where users enter information in and it gets time stamped to a MySQL Database.
What I want to do is display to the users how many entries are entered at any given time over the course of an hour.
So an Entries Per Hour kinda deal.
Would I make the query look like:
SELECT count(*) FROM myTable WHERE date_entered >= AN AN HOUR AGO FROM NOW
Not sure if I would use SQL's time functions or PHP's Time functions, and how