A Flash Developer Resource Site

Results 1 to 3 of 3

Thread: self delete

  1. #1
    Senior Member
    Join Date
    Aug 2000
    Location
    Seoul, South Korea
    Posts
    1,310
    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]

  2. #2
    Registered User
    Join Date
    Feb 2001
    Posts
    13,041
    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

  3. #3
    Senior Member
    Join Date
    Aug 2000
    Location
    Seoul, South Korea
    Posts
    1,310
    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
  •  




Click Here to Expand Forum to Full Width

HTML5 Development Center