Re: Please help me as fast as possible.. very important!!
| From: | Radwan Aladdin | Date: | Tue, 20 Jan 2004 10:05:00 +0000 |
| Subject: | Re: Please help me as fast as possible.. very important!! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-175116@lists.php.net to get a copy of this message | ||
Where can I fin tutorials about it? (CRON Tab)?
Regards..
----- Original Message -----
From: "Nick JORDAN" <nick.jordan@danone.com>
To: "Radwan Aladdin <raladin" <raladin@emirates.net.ae>
Sent: Tuesday, January 20, 2004 1:56 PM
Subject: Re: [PHP] Please help me as fast as possible.. very important!!
> > 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..
>
>
> As far as I'm aware, that's not possible in MySQL, however you could write
> a small script in PHP (or, indeed, some other language) which would
> increment the counter, and which would be run at intervals via cron (for
> instance).
>
> A better solution, however, would be to include a timestamp in your
> database, then, when data is requested, calculate how many units of ten
> minutes have passed and adjust your counter accordingly.
>
> Nick
>