Who's Online...

[phpn00bf4life]

Hi, i'm going to build a who's online for a client, but I have a problem. I don't know how to do it with this kind of db. (done by a past programmer).

Here it is

+----------------+--------------+
+ user_id + int(11) +
+----------------+--------------+
+ real_time + datetime +
+----------------+--------------+

now i don't understand, if i wanted to collect all users active in the last 5 minutes, how i would go about doing this because what the db does is stores them, and when they were last active. Any ideas on how to do it? (DB is MySQL) (PHP 4.3.11)

[devinemke]

SELECT * FROM table WHERE DATE_SUB(CURDATE(), INTERVAL 5 MINUTE) <= real_date

[phpn00bf4life]

okay thx, i'll try that.

[phpn00bf4life]

like this:

$__getOnline = mysql_query( "SELECT * FROM online WHERE user_id = '$id' AND DATE_SUB(CURDATE(), INTERVAL 5 MINUTE) <= real_date LIMIT 1" );

would that work?