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]