newbie - problems with Select and timestamp(14) calculation

From: Date: Thu, 18 Oct 2001 10:41:14 +0000
Subject: newbie - problems with Select and timestamp(14) calculation
Groups: php.db 
Request: Send a blank email to php-db+get-13465@lists.php.net to get a copy of this message
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

« previous php.db (#13465) next »