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

2004-01-20 Thread Michael Egan
http://www.google.com/linux?hl=en&lr=&ie=ISO-8859-1&q=cron+tutorials&btnG=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 
> 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!![Scanned]

2004-01-20 Thread Michael Egan
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