If I have 15 thousand records of ip addresses and access times like:
IP Now() media.id -------------------------------------------------------------- 10.1.7.205 20050329121645 67 68.252.32.76 20050329095923 72
And, I want to set the cut-off time to 15 minutes...
Basically, if the user has not requested media on the server in last 15 minutes, the user has logged off....
can someone point me in the right direction as I am very new to more advanced mysql queries
many thanks
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]