[RESOLVED] get users in past 24 hours

[jasondavis]

Im trying to get a count of new users on my site within the past 24 hours, here is my code

SELECT count(submit_date) FROM friend_reg_user WHERE submit_date < DATE_SUB( NOW(), INTERVAL 24 HOUR)

the problem is I have around 32,000 users and the result of this is like 30,500, It should show me the number of records where the number of rows for submit_date where this value is within the past 24 hours

PS the row is a datetime

[burfo]

It looks to me that you are using the wrong comparison operator, because right now you'd get everything that is older than 24 hours. Try using greater-than instead of less-than.

[jasondavis]

oh I feel like a dummy now lol thanks you are right