Im using PhpMyadmin Mysql
this is my sql record from database, How can I use timediff to subtract NOW(); from last activity which is user is user1 and get how many minutes user1 is idle.
id lastActivity user
1 2015-05-08 00:20:40 user1
2 2015-05-08 00:32:29 user2
Aucun commentaire:
Enregistrer un commentaire