I'm wanting to put a date ie. 23/03/02 into a database field and have it expire (delete itself) at a certain time, that being 11:59 PM
Can anyone suggest how to go about this?
I've heard a crontab file can achieve is....any info on this.
[Edited by micmac on 04-15-2002 at 08:25 AM]
you will probably have to write a script that does the database maintenance (either pure sql or php) and call that script from the crontab.
BTW: try using true date/time fields rather than text fields for the date - it really pays if you do not have to program yesterday and tomorrow functions
Hi Musicman...as usual thanks for the post.
In regards to the true date and times are you referring to UNIX time stamps?
Click Here to Expand Forum to Full Width