Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 4 of 4

Thread: expiring entry

  1. #1
    Member
    Join Date
    Apr 2004
    Posts
    74
    Member #
    5667
    Is there a way to make an SQL entry expire after a certain amount of time?
    Like if I had a bulletin board, but I wanted posts to only remain for a month?

    Thanks in advance
    Jeff Mills

  2.  

  3. #2
    WDF Staff Wired's Avatar
    Join Date
    Apr 2003
    Posts
    7,657
    Member #
    1234
    Liked
    137 times
    Depends on what you mean. When posts expire in a forum, by vB default they aren't shown anymore, but they're still in the DB.

    do you want to delete them from the DB after a month, or simply hide them from default view?
    The Rules
    Was another WDF member's post helpful? Click the like button below the post.

    Admin at houseofhelp.com

  4. #3
    Member
    Join Date
    Apr 2004
    Posts
    74
    Member #
    5667
    Hey Wired, thanks for the reply. Actually not deleting it would be a better option. Then if the same user wanted to post the same thing again, they could just renew it, as opposed to resubmitting the entire thing again.
    Jeff Mills

  5. #4
    Senior Member
    Join Date
    Jul 2005
    Location
    S.Wales, UK
    Posts
    250
    Member #
    10742
    Every post has a timestamp

    When displaying the posts only display those that have a date less than a specified date.
    Paul Creedy
    Visit my community site at: www.rhonddacynontaff.com
    My hosting: www.rcthosting.com
    My Content Management product: www.dynamiccontenteditor.com


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 11:56 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com