Re: [PHP-DB] newbie - problems with Select and timestamp(14) calculation

2001-10-18 Thread Russ Michell
(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 log

Re: [PHP-DB] newbie - problems with Select and timestamp(14) calculation

2001-10-18 Thread p.whiter
- 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 : I am trying to set-up a type of anti-flood block on one of my forms

Re: [PHP-DB] newbie - problems with Select and timestamp(14) calculation

2001-10-18 Thread Russ Michell
into a big headache. Thanks again 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: [PHP-DB] newbie - problems with Select and timestamp(14) calculation

Re: [PHP-DB] newbie - problems with Select and timestamp(14) calculation

2001-10-18 Thread Jason Wong
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

Re: [PHP-DB] newbie - problems with Select and timestamp(14) calculation

2001-10-18 Thread Jason Wong
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 and

Re: [PHP-DB] newbie - problems with Select and timestamp(14) calculation

2001-10-18 Thread Jyrki Leppala
: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 saves the time as '20011018134612' this is the same format as the NOW()+0 I think? I have tried various methods