[PHP] Please help me as fast as possible.. very important!!
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..
RE: [PHP] Please help me as fast as possible.. very important!![Scanned]
I've never done it but I can only imagine you'd need to run some sort of CRON job to effect this at regular intervals. HTH, Michael Egan -Original Message- From: Radwan Aladdin [mailto:[EMAIL PROTECTED] Sent: 20 January 2004 09:45 To: [EMAIL PROTECTED] Subject: [PHP] Please help me as fast as possible.. very important!![Scanned] Importance: High 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.. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 [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
RE: [PHP] Please help me as fast as possible.. very important!![Scanned]
http://www.google.com/linux?hl=enlr=ie=ISO-8859-1q=cron+tutorialsbtnG=Google+Search -Original Message- From: Radwan Aladdin [mailto:[EMAIL PROTECTED] Sent: 20 January 2004 10:05 To: Nick JORDAN Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Please help me as fast as possible.. very important!![Scanned] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Please help me as fast as possible.. very important!!
The only thing you need to know is that you enter a file in the cron dir (in /etc I think) and you have the following line in that file: 52 10 * * * /usr/bin/php /home/mainwebsite_html/file.php this line runs the file.php every day at 10.52 (min hour week month year) (php dir) (file location) - the star means any day-month-year [i'm not sure if it's week month year or year month week] If there is a cron.daily or monthly ...etc... you don't need to specify the first part (date time stuff) e.g. /usr/bin/php /home/mainwebsite_html/file.php - Original Message - From: Radwan Aladdin [EMAIL PROTECTED] To: Nick JORDAN [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 12:05 PM 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 [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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Please help me as fast as possible.. very important!!
Im not sure about php but if you are desperate then you could also do it in VB with a timer control. -Original Message- From: Radwan Aladdin [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 11:45 AM To: [EMAIL PROTECTED] Subject: [PHP] Please help me as fast as possible.. very important!! Importance: High 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.. Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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: [EMAIL PROTECTED] -Original Message- From: Radwan Aladdin [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 January 2004 9:05 PM To: Nick JORDAN Cc: [EMAIL PROTECTED] 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 [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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Please help me as fast as possible.. very important!!
Radwan Aladdin wrote: 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.. I am not aware of any such functionality within MySQL. However if you have a one-one relationship between a period of time and an incremental, could you not simply INSERT a timestamp and then compare with times with NOW, and then divide by your time period? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
