Problem with mysql_query...

[phpn00bf4life]

Hi all

🙂

Here's the info first:
MySQL table Online:
user_id(int_11) :: real_time(datetime())

$query = mysql_query("SELECT * FROM online WHERE DATE_SUB(CURDATE(), INTERVAL 5 MINUTE) <= real_time ORDER BY user_id DESC");

This is selecting users who can't be online, ... there's now way! here's what it's getting

look at these two very different times:

user_id: 6 | real_time: 2005-07-01 02:20:57
user_id: 1 | real_time: 2005-07-01 16:01:00

Now how can it be getting those, if it's supposed to select all users on in the past 5 minutes...

[konsu]

consider using NOW() instead of CURDATE(). CURDATE() just returns the date. no time information. in addition, this might be helpful: http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html