yim111
Novice
Dec 7, 2002, 4:04 PM
Post #1 of 2
(206 views)
|
|
Perl/MySQL and showing messages based on time
|
Can't Post
|
|
Hello,
I am trying to write a script that will insert messages into a MySQL database, with a timestamp, and display only messages that have not expired.
The input from the html form is in the form of:
Name:_____
Email:____
Message:____
Expires:____
Expires is an hourly value, either 1, 2, 3, 4, or 24 hours. Basically a user fills in the form, selects one of the 5 hourly values and submits. The script would insert the values in the database, and timestamp the entry. There would be another link/html page to display all entries in the datebase - that haven't expired. I'm not sure if I will need a seperate script (and cron job?) to remove expired entries.
Any assistance on this project is really appreciated!
-jim
|
MAIN
SEARCH
WHO'S 
LOG 