ed out, still I have
learnt a lot in the process, which is what it's all about I guess!
Thanks again
Paul
- Original Message -----
From: "p.whiter" <[EMAIL PROTECTED]>
Subject: Re: [PHP-DB] newbie - problems with Select and timestamp(14)
calculation
: Thanks to everyone for
t;
Sent: Thursday, October 18, 2001 6:21 PM
Subject: Re: [PHP-DB] newbie - problems with Select and timestamp(14)
calculation
: Hi,
:
: There seems to be several ways to compare time. This is what I use
: to log out visitors if they do nothing in 1000 seconds. This would be
: easier to do with sessio
CTED]>
To: <[EMAIL PROTECTED]>
Date sent: Thu, 18 Oct 2001 16:11:23 +0100
Subject:Re: [PHP-DB] newbie - problems with Select and timestamp(14)
calculation
> Thanks for the reply, but the Timestamp(14) column (log_time) in my DB
> s
in
>>Paul
>>
>>- Original Message -
>>From: "Russ Michell" <[EMAIL PROTECTED]>
>>To: "p.whiter" <[EMAIL PROTECTED]>
>>Cc: <[EMAIL PROTECTED]>
>>Sent: Thursday, October 18, 2001 12:24 PM
>>Subject: Re: [PH
Use this instead
SELECT user_ip FROM clinic_log WHERE user_ip = '$pw_userIP' AND
clinic_log.log_time + interval 300 second >= Now();
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: "p.whiter" <[EMAIL PROTECTED]>
To: <[EMAIL
ve, but it is turning
>into a big headache.
>
>Thanks again
>Paul
>
>- Original Message -
>From: "Russ Michell" <[EMAIL PROTECTED]>
>To: "p.whiter" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Thursday, Octobe
On Thursday 18 October 2001 23:11 pm, p.whiter wrote:
> Thanks for the reply, but the Timestamp(14) column (log_time) in my
> DB saves the time as '20011018134612' this is the same format as the
> NOW()+0 I think?
>
> I have tried various methods to get this to work. I've gone through
> the manual
[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 18, 2001 3:43 PM
Subject: Re: [PHP-DB] newbie - problems with Select and timestamp(14)
calculation
: On Thursday 18 October 2001 18:41 pm, p.whiter wrote:
: > Hi
: > I am trying to set-up a type of anti-flood block on on
On Thursday 18 October 2001 18:41 pm, p.whiter wrote:
> Hi
> I am trying to set-up a type of anti-flood block on one of my forms,
> the way I am doing this is that when the first submission is made I
> log various details into a user_log table including IP no and a
> Timestamp (14) column called l
er simple query to achieve, but it is turning
> into a big headache.
>
> Thanks again
> Paul
>
> - Original Message -
> From: "Russ Michell" <[EMAIL PROTECTED]>
> To: "p.whiter" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
er 18, 2001 12:24 PM
Subject: Re: [PHP-DB] newbie - problems with Select and timestamp(14)
calculation
: >(NOW()+0)
: Not sure what the +0 achieves?? Try with just NOW().
:
: Cheers.
: Russ
:
: On Thu, 18 Oct 2001 11:41:14 +0100 "p.whiter" <[EMAIL PROTECTED]>
wrote:
:
: > Hi
>(NOW()+0)
Not sure what the +0 achieves?? Try with just NOW().
Cheers.
Russ
On Thu, 18 Oct 2001 11:41:14 +0100 "p.whiter" <[EMAIL PROTECTED]> wrote:
> Hi
> I am trying to set-up a type of anti-flood block on one of my forms, the way
> I am doing this is that when the first submission is made I
12 matches
Mail list logo