Help with a query?

[kh99]

Originally Posted by nhawk

You were on the right track...

The timestamp will contain the hour of 00:00:00 so this will give only the date chosen. (between 2012-02-22 00:00:00 and 2012-02-22 11:59:59)

SELECT userid, username, COUNT(*) as count FROM post 
WHERE visible=1 AND 
UNIX_TIMESTAMP('2012-02-22') >= dateline AND
UNIX_TIMESTAMP('2012-02-23') < dateline
GROUP BY userid ORDER BY count DESC

That doesn't work, you've got the comparisons backward. What I meant was I tried to think of a way where, if you wanted to change the date you'd only have to change it in one place instead of two.