Posted by Oli Filth on 10/10/05 17:29

Maximus wrote:
> Jerry Stuckle wrote:
> > Maximus wrote:
> > > I need to make a script that whenever somethin is added to the db, it
> > > will run and grab those info. Worth sayin that there's no time limit
> > > for the db data addition.
> > >
> >
> > Which database? What does it need to do?
> >
> > Sounds like you need a trigger.
> >
>
> Exactly,
>
> I need a 24/7 trigger
> the trigger is a PHP script
> but i don't know how to make it go 24/7 other than using a cron job.


He means an SQL trigger. Various RDBMS support triggers, e.g. MySQL
5.0.2+, MS SQL Server, PostgreSQL.

The idea of a trigger is that the database server itself runs a
sequence of instructions whenever a record is inserted, updated or
deleted.

--
Oli

[Back to original message]