What's wrong with this query?

[sw0o0sh]

In this personal forum I am coding I'm trying to grab the users online in the past 5 minutes. Every time a user goes to a new page it updates their "last_movement" field in the SQL database. Here's the query:

 

$i=0;
$sel_users_online = mysql_query("SELECT * FROM rscd_members WHERE last_movement > '" . date("Y-m-d H:i:s", time()-60*5) . "'");
while($grab_d = mysql_fetch_array($sel_users_online)){
echo "<a href='?act=profile&id=".$grab_d['id']."'>" . rank($grab_d['status']) . $grab_d['username'] . "</a>" . (($i < (($total_online) - 1)) ? ", " : null);
$i++;
}

 

Here's an example of an entry stored in last_movement, which is clearly (Y-m-d H:i:s):

 

2009-11-13 23:32:30

 

Can anybody help me out here?

[joel24]

wat type of field is "last_movement"? datetime?

if so you can change that sql to

$sel_users_online = mysql_query("SELECT * FROM rscd_members WHERE last_movement > NOW() - INTERVAL 5 MINUTE");

 

wat error are you getting? its just not selecting any members?

[sw0o0sh]

wat type of field is "last_movement"? datetime?

if so you can change that sql to

$sel_users_online = mysql_query("SELECT * FROM rscd_members WHERE last_movement > NOW() - INTERVAL 5 MINUTE");

 

wat error are you getting? its just not selecting any members?

 

 

Yeah, it's simply just not selecting any members. It's field_type is "TIMESTAMP", however I tried your method and it seems to work fine

 

Is there anywhere I can read a manual on further working with the INTERVAL XX XX type thing?

[joel24]

hmm there doesn't seem to be a dedicated page for it, but

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add

has a bit