Look this up on mysql.com:

TIME_TO_SEC(NOW())

It may be what you are after.

-Jason Garber
IonZoft.com




At 12:40 PM 10/18/2001 -0400, Jason G. wrote:
>I do not know if it suites your purposes, but I find INT UNSIGNED NOT NULL 
>does great at holding a UNIX_TIMESTAMP() value, and is easy to manipulate...
>
>-Jason Garber
>IonZoft.com
>
>
>At 02:02 PM 10/18/2001 +0100, p.whiter wrote:
>>Hi
>>Thanks for your reply, I have tried this using NOW()  and NOW()+0, there is
>>no difference, I think I have narrowed the problem down to the time part of
>>the timestamp being disregarded, as I have written the query below it is
>>making the calculation using days rather than seconds......
>>
>>This should really be a rather 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]>
>>Sent: Thursday, October 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
>>: > 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 log_time. Now if the button is clicked again the php script will
>>run
>>: > the following query:
>>: >
>>: > SELECT user_ip  FROM clinic_log  WHERE user_ip = '$pw_userIP' AND
>>: > (((NOW()+0) - clinic_log.log_time ) < 300)
>>: >
>>: > What I am (trying) doing here is to check the users IP ($pw_userIP)
>>against
>>: > the user_ip column in the database and if it matches then check to see
>>: > whether it has been there for less than 300 seconds.
>>: >
>>: > I have just spent the last couple of hours trying to get this
>>: > working......it doesn't want to know. It keeps finding the matching IP
>>and
>>: > disregarding the time calculation......
>>: >
>>: > Thanks for any help.
>>: > Paul
>>
>>
>>
>>--
>>PHP Database Mailing List (http://www.php.net/)
>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>For additional commands, e-mail: [EMAIL PROTECTED]
>>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to