time based actions

[Roderik]

Is it possible to perform actions at certain moments. Like resetting a
database record every first day of month?

regards,

Roderik

[Frank]

Roderik wrote:

Is it possible to perform actions at certain moments. Like resetting a
database record every first day of month?

regards,

Roderik

You'll have to start the php interpreter from some external sheduler,
like cron on linux or at(?) on a windows box.

[Sandman]

In article <41************ **********@drea der2.news.tisca li.nl>,
Roderik <ma**@roderik.n et> wrote:

Is it possible to perform actions at certain moments. Like resetting a
database record every first day of month?

Of course, I do it all the time. Question is what kind of host you are running
PHP on. If it's linux/unix, you'd probably use 'cron'. If it's Windows you'll
probably built that built-in schedular whatever-its-name-is, if that can
execute shellscripts.

--
Sandman[.net]

[TreeNet Admin]

In article <mr************ **********@indi vidual.net>, [e-mail]
says...

In article <41************ **********@drea der2.news.tisca li.nl>,
Roderik <ma**@roderik.n et> wrote:

Is it possible to perform actions at certain moments. Like resetting a
database record every first day of month?

Of course, I do it all the time. Question is what kind of host you are running
PHP on. If it's linux/unix, you'd probably use 'cron'. If it's Windows you'll
probably built that built-in schedular whatever-its-name-is, if that can
execute shellscripts.

This is probably more suited to a forum for your particular database.
Web server and its plugins should not be involved in regular DB internal
maintenance.

Most DB have PROCEDURE operations, create one to do what you want and
having the OS run it through one of the above schedulers.
Some full-SQL databases also have TRIGGER command to run SQL
on/before/after certain DB actions.

ie:
in DB:

CREATE PROCEDURE monthly
BEGIN
UPDATE test SET ThisMonth=MONTH (NOW());
END

OS runs <every day, or month, or week, whatever>
mysql -u user -ppass -Dtest --exec="monthly() "

--
AJ
Treehouse Networks abuse@
www.treenetnz.com

[Sundial Services]

TreeNet Admin wrote:

In article <mr************ **********@indi vidual.net>, [e-mail]
says...

In article <41************ **********@drea der2.news.tisca li.nl>,
Roderik <ma**@roderik.n et> wrote:

> Is it possible to perform actions at certain moments. Like resetting a
> database record every first day of month?

Of course, I do it all the time. Question is what kind of host you are
running PHP on. If it's linux/unix, you'd probably use 'cron'. If it's
Windows you'll probably built that built-in schedular
whatever-its-name-is, if that can execute shellscripts.

This is probably more suited to a forum for your particular database.
Web server and its plugins should not be involved in regular DB internal
maintenance.

Most DB have PROCEDURE operations, create one to do what you want and
having the OS run it through one of the above schedulers.
Some full-SQL databases also have TRIGGER command to run SQL
on/before/after certain DB actions.

ie:
in DB:

CREATE PROCEDURE monthly
BEGIN
UPDATE test SET ThisMonth=MONTH (NOW());
END

OS runs <every day, or month, or week, whatever>
mysql -u user -ppass -Dtest --exec="monthly() "

If you don't have that, then PHP can be used to build scripts that are
designed to be run from the command-line via the 'php' command.