-
Hi all,
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.
Cheers,
micmac
[Edited by micmac on 04-15-2002 at 08:25 AM]
-
Hi,
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
Musicman
-
Hi Musicman...as usual thanks for the post.
In regards to the true date and times are you referring to UNIX time stamps?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|