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 ? 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 Link to comment https://forums.phpfreaks.com/topic/89806-time-difference-10min/#findComment-460255 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.