shane18 Posted February 9, 2010 Share Posted February 9, 2010 $CHANAGE = $DATABASE_LINK->query("SELECT `name` FROM `users` WHERE `last_activity` > TIME()"); How can I make that work without going $TIME = time(); .... Link to comment https://forums.phpfreaks.com/topic/191447-mysql-time/ Share on other sites More sharing options...
PravinS Posted February 9, 2010 Share Posted February 9, 2010 What is data type of "last_activity" field. It it is DATETIME then you can directly compare it with NOW() function in query. Link to comment https://forums.phpfreaks.com/topic/191447-mysql-time/#findComment-1009255 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.