select everything > 5 minutes ago.

[Anon]

i'm trying to query for visitors of the website who have visited within the last five minutes.. but i can't get this query right. please help:

select username from users where last_visit > (CURTIME() - 300)

this doesn't work, any suggestions would be appreciated. thanks.

[Anon]

well, the sql standard way of doing it is:

select username from users where last_visit > current_date - interval '5 minutes'

You haven't told us what database you're using, so I can't do much more than this. if it's mysql, then it doesn't have standard time handling, so I don't know what you should do.

Chris