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. -afan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]