Dec 7, 2002, 4:04 PM
Post #1 of 2
Perl/MySQL and showing messages based on time
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:
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!