Users Online

[ShoeLace1291]

I have a database that stores member information in a table called `members` with a column that shows when they were last active called `lastActive`.  The lastActive column is a strtotime date and time string like strtotime(date("M jS, o g:i a"))  How would I list the users that have been active in the last 15 minutes?

[p2grace]

I'd recommend also storing a last active datetime field... more practical and functional

[ShoeLace1291]

Ok, so how would I print the time that it would be 15 minutes before the current time?

[p2grace]

You'd have to create a comparison variable in php to use in the sql statement.  Something like the following should do the trick.

 

<?php
$compare_time = date("Y-m-d H:m:s",mktime(date("H"),date("m") - 15,0,date("m"),date("d"),date("Y")))
?>