why not simply store the server time at log in in the DB after a successful
log in together with the IP address; and at the next log in request perform
a SQL time difference comparison?
----- Original Message -----
From: "wade" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 10:53 PM
Subject: [PHP-DB] Flush database
> I am storing IP addresses in a database, but after an hour has passed I
> want to delete all the IP addresses from that database. I want to do
> this based on the server time. Example.. Someone comes to my web page, I
> store their IP address in my database. So now I write a PHP script that
> says if that IP returns to my page within an hour, they can't view my
> page. If they come back after an hour has passed they can view the
> contents of that page. but only after an hour has passed.
> Can anyone help me with the syntax or functions that will clear the
> database after an hour of waiting has passed?
> Is this possible? Any suggestions, logic or any help on this matter will
> be greatly appreciated.
> Thank you
> Should you have any questions, comments or concerns, feel free to call
> me at 318-338-2033.
> Thank you for your time,
> Wade Kelley, Design Engineer
> Bayou Internet...(888) 30-BAYOU...http://www.bayou.com
> Mississippi Internet...(800) MISSISSIPPI...http://www.mississippi.net
> Vicksburg Online...(800) MISSISSIPPI...http://www.vicksburg.com
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php