Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    6

    Unanswered: How to make a timer inside the database?

    Hi all

    Is it possible in mySQL to put a timer that changes a value inside a row in a table every while?

    For example : Add "1" to the value very 10 minutes for example.. Field number = 5 after ten minutes = 6 after another 10 minuste = 7..Etc..

    Is it possible?And how?

    Regards..

  2. #2
    Join Date
    Jan 2004
    Posts
    24
    Not that I am aware of. You can write a cron script that could easily do it. But I don't think you can do that in 3.x or 4.x. With 5.x maybe, haven't used it enough to really know.

    Donny
    http://www.phpscripts.com/

  3. #3
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137

    Re: How to make a timer inside the database?

    You probably don't need to save a value like that in the database. It would make more sense to save an initial value and do calculations in your SELECT statement based upon the length of time since the record was created.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •