mysql php timestamp query

Question

I have a online list, I want it to remove the users off list after a certain amount of time they have been inactive.

How would I make the second query work with what im trying to do?

<?php
//On page load with a logged-in user
mysql_query("UPDATE `users` SET `last_activity` = NOW() WHERE `username` = '" . ($_SESSION['username']) . "'");

mysql_query("UPDATE `users` 
             SET `online` = 0 
             WHERE `last_activity` < NOW('+11 minutes') ");
?>

Right now it, takes away everyone off the list no matter how much time their timestamp is.

Mark · Accepted Answer · 2013-01-07 02:42:29Z

2

You need to use date_sub:

DATE_SUB(NOW(),INTERVAL 11 MINUTE)

answered Jan 7, 2013 at 2:42

Mark

2,4734 gold badges26 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Nick Over a year ago

Alright thanks im trying it now, gotta wait some time to see if it works :)

Mark Over a year ago

if you want to test it change MINUTE to SECOND

Nick Over a year ago

Works grea tthank you very much I've been dealing with this problem for hours XD

Collectives™ on Stack Overflow

mysql php timestamp query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related