query based of online or offline?

[Daron]

Hey i have something im trying work out, i have a tier of ranks, and each rank is earned by being online(well thats what i want) the way i was trying go about it is on my hourly cron have it set so those online go up a rank and those offline go down a rank, BUT i dont know how to properly run that query. i tried this

$db->query("UPDATE users SET rank=rank+1 WHERE laston >= time()-15*60");

 

i think its because this "time()" but im not really sure how to pull this off ????:confused:

[Seker]

$db->query("UPDATE users SET rank=rank+1 WHERE(laston >= (" . time() . "-(15*60)))");

 

Maybe? Not sure, though.

[Djkanna]

You could always substitute time() for UNIX_TIMESTAMP()

[Daron]

ohhh ^_^ thanx Seker! it worked!!!!!! Thanx a lot