Autodelete?

From: Ganon (evillordganon_at_hotmail.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 15:52:09 -0000

I have a database where I'm storing some user information, but I only want
the entries to remain in the database for a certain amount of time (say 72
hours). I have a datetime field in my database so I can manually tell, but
obviously that will be a real headache.

I thought maybe I could do some php in a private script to search through
the database and delete rows where time has expired, but not sure really how
that would work.

Also, I doubt it... but is there are way to set up mySQL entries to
autodelete after a certain time?

Hope you guys can help with some advice.

Relevant Pages

  • RE: repeated conversion of data summarized into rows and columns
    ... the database name, table name and field names I used in the code. ... Dim currentUser As String ... ' Column Pointer to work through Hour entries ... Dates and to the HoursDates table and containing a usage entry. ...
    (microsoft.public.excel.misc)
  • Re: Multiple Record Inputs with one Form
    ... For intCount = 1 To Me! ... the entries from the form inputed. ... "Jeff Boyce" wrote: ... database will let you do. ...
    (microsoft.public.access.formscoding)
  • Re: Commas in URLs?
    ... > entries are also commonly used for this purpose, ... > used bibliographic database app EndNote has a "URL" field in each entry. ... > the multiple keywords in EndNote Keywords field, ... > delimiter for individual keywords in that field is the comma. ...
    (comp.infosystems.www.authoring.html)
  • New Shareware: MyIdeasJournal version 1.1
    ... MyIdeasJournal is a database program that you can use to capture ... Searching for entries by subject is also very easy and fast. ... listbox item. ... you are either in Search mode or in Browse mode. ...
    (comp.software.shareware.announce)
  • Re: Multiple Record Inputs with one Form
    ... Dim strSQL As String ... Lets say we start out with two entries. ... "Jeff Boyce" wrote: ... database will let you do. ...
    (microsoft.public.access.formscoding)