[RESOLVED] need help with time

[jasondavis]

Part of my mysyl quiry

$logoutsql="select * from friend_online where lastactive<=NOW()-20000";

It appears lastactive is in this format 0000000000 a 10 digit unix timestamp?
So how would I minus 10 or 20 minutes from the current time in this format

[bradgrafelman]

I would recommend converting lastactive to a DATETIME column. In your queries that update this column, you'd simply do:

UPDATE friend_online SET lastactive=NOW() WHERE id=5 LIMIT 1

Then, for your query, you'd do:

SELECT col1, col2 FROM friend_online WHERE lastactive <= DATE_SUB(NOW(), INTERVAL 10 MINUTE)

[jasondavis]

I just tried this but it didnt work well

heres some other similar code from my site

 $inactive = time()-(60*60*30);
 $sql_delete="DELETE FROM friend_online WHERE lastactive < $inactive";

If I can figure out how to do time() - 10 minutes and time() - 20 minutes

[jasondavis]

ok got your method to work now, thank you 🙂