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:
<?php
$current_time = time();
$start_time = ($current_time - 15*60);
SELECT * FROM members WHERE last_access >= '$start_time'
?>
But, I know there is something like:
SELECT * FROM members WHERE last_access BETWEEN(CURTIME(), INTERVAL
15 MIN)
?!?
Thanks for any help.
If you mean "what is the syntax of BETWEEN?," it's in this section
of the manual:
http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]