Where can I fin tutorials about it? (CRON Tab)? Regards.. ----- Original Message ----- From: "Nick JORDAN" <[EMAIL PROTECTED]> To: "Radwan Aladdin <raladin" <[EMAIL PROTECTED]> 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
