Nothing' wrong- I just didn't know :)
Yup! It works just fine!
Thanks Paul for your help!
-afan
> At 22:29 -0500 4/27/06, Afan Pasalic wrote:
>>No, not exactly. More as "there is a solution"...
>>What would be the best way to do?
>>
>>-afan
>
> What's wrong with WHERE last_access >= NOW() - I
At 22:29 -0500 4/27/06, Afan Pasalic wrote:
No, not exactly. More as "there is a solution"...
What would be the best way to do?
-afan
What's wrong with WHERE last_access >= NOW() - INTERVAL 1 HOUR ?
You don't want CURTIME(), I think, because that has only time, not the
date.
Paul DuBois w
No, not exactly. More as "there is a solution"...
What would be the best way to do?
-afan
Paul DuBois wrote:
At 20:52 +0200 4/27/06, [EMAIL PROTECTED] wrote:
Hi,
I was trying to list all registeed users they are "online" last 15
minutes.
I can do it by using timestamp:
= '$start_time'
?>
At 20:52 +0200 4/27/06, [EMAIL PROTECTED] wrote:
Hi,
I was trying to list all registeed users they are "online" last 15 minutes.
I can do it by using timestamp:
= '$start_time'
?>
But, I know there is something like:
SELECT * FROM members WHERE last_access BETWEEN(CURTIME(), INTERVAL 15 MIN)
?
Hi,
I was trying to list all registeed users they are "online" last 15 minutes.
I can do it by using timestamp:
= '$start_time'
?>
But, I know there is something like:
SELECT * FROM members WHERE last_access BETWEEN(CURTIME(), INTERVAL 15 MIN)
?!?
Thanks for any help.
-afan
--
MySQL General
