This is it. I quit for today... Change "minutes" to "minute" and I promise
to be more careful next time -- ROFLMAO!
-S
[EMAIL PROTECTED] wrote on 03/29/2005 02:59:09 PM:
> TYPO ALERT!!! I left out the all important word INTERVAL. The query
> should read:
>
> SELECT accesstime
> FROM userlog
>
TYPO ALERT!!! I left out the all important word INTERVAL. The query
should read:
SELECT accesstime
FROM userlog
where accesstime > (NOW() - INTERVAL 15 minutes)
and IP='10.1.7.205'
LIMIT 1;
Sorry all!
-S
[EMAIL PROTECTED] wrote on 03/29/2005 02:50:35 PM:
> Graham Anderson <[EMAIL PROTECTED]>
Graham Anderson <[EMAIL PROTECTED]> wrote on 03/29/2005 02:20:48 PM:
> 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
>
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 20
