RE: How to make a timer inside the database?
| From: | Rolf van de Krol | Date: | Tue, 20 Jan 2004 14:54:43 +0000 |
| Subject: | RE: How to make a timer inside the database? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-175142@lists.php.net to get a copy of this message | ||
Hi Radwan,
There's something like a MySQL-manual when you want to know something like
this, but I understand it if you don't want to read it at all. It's a kind
of big.
I don't expect it is possible top put a timer in MySQL, but why shouldn't
you put the start time in the database. Everytime you need the number you
described, you have to calculate the minutes which expired from the start
time. Then you divide the number of minutes by 10 and round it down to zero
decimals.
Is this a solution? If not please explain.
Rolf
-----Oorspronkelijk bericht-----
Van: Radwan Aladdin [mailto:raladin@emirates.net.ae]
Verzonden: dinsdag 20 januari 2004 9:30
Aan: php-general@lists.php.net
Onderwerp: 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..