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]>
