I am trying to determine the average time that a Distinct IP address is using the server


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]



Reply via email to