RE: [PHP] Please help me as fast as possible.. very important!!

http://www.unixgeeks.org/security/newbie/unix/cron-1.html Chris Kay (CK) Eleet Internet Services M: 0415 451 372 P: 02 4620 5076 F: 02 4620 7008 E: chris@eleet.com.au -----Original Message----- From: Radwan Aladdin [mailto:raladin@emirates.net.ae] Sent: Tuesday, 20 January 2004 9:05 PM To: Nick JORDAN Cc: php-general@lists.php.net Subject: Re: [PHP] Please help me as fast as possible.. very important!! 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php