LanceT Posted March 8, 2007 Share Posted March 8, 2007 I want to create a system that allows people to see who is online. So I'm thinking that whenever someone logs in, it would update a table that shows when they last logged in. But I'm not sure how I could possibly compare it with the current time? Link to comment https://forums.phpfreaks.com/topic/41814-users-online/ Share on other sites More sharing options...
artacus Posted March 8, 2007 Share Posted March 8, 2007 SELECT * FROM logs WHERE last_login > DATE_SUB(NOW(), INTERVAL 5 MINUTE) Link to comment https://forums.phpfreaks.com/topic/41814-users-online/#findComment-202781 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.