I basically want a query which will tell me the most posts a single user has made in a single day. I'm not sure if this can be done with a MySQL query but I have a query that tells how many posts a certain user has on a specific day but I want it to figure out which day that user has made the most posts and how many posts it was.
Anyways, here's my current query:
SELECT COUNT(*) as total
WHERE DATE BETWEEN Unix_Timestamp('2011-10-20 00:00:00') AND Unix_Timestamp('2011-10-21 00:00:00')