crashmaster Posted February 6, 2008 Share Posted February 6, 2008 I have a column in userDB "last_visit" ... data format ex.: '2008-02-05 13:44:15' How can I do a query, which selects all users, which was on web last 10 minutes ? Quote Link to comment https://forums.phpfreaks.com/topic/89806-time-difference-10min/ Share on other sites More sharing options...
Barand Posted February 6, 2008 Share Posted February 6, 2008 SELECT .... WHERE last_visit > NOW() - INTERVAL 10 MINUTE Quote Link to comment https://forums.phpfreaks.com/topic/89806-time-difference-10min/#findComment-460255 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.