List:General Discussion« Previous MessageNext Message »
From:Daniel da Veiga Date:April 20 2006 6:49pm
Subject:Re: How to initiate a prog. via mysql
View as plain text  
On 4/20/06, Dan Nelson <dnelson@stripped> wrote:
> In the last episode (Apr 20), Jay Blanchard said:
> > [snip]
> > I need to start a prog. as soon as a particular field in the mySQL 4.x
> > is
> > changed. ie. when in Flag table if_flag is set to '1'  i need to start a
> > script.
> > The script will be in PHP.
> > Pl. tell me how to do so on mySQL 4.x.
> > [/snip]
> >
> > Triggers are not available in 4.x, you will need 5.x
>
> And even triggers won't help.  You will need to have your php script
> poll mysql for the changes.
>

I didn't get it, you need to run the PHP script at the client or at
the server? I mean, if we're talking of a web page, the same script
that updates that field should launch the script. If not, you're
programming PHP locally, am I right? And if so, you'll have to keep it
running and as Dan said check the value constantly. Kinda weird if you
ask me.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
Thread
How to initiate a prog. via mysqlabhishek jain20 Apr
RE: How to initiate a prog. via mysqlJay Blanchard20 Apr
  • Re: How to initiate a prog. via mysqlDan Nelson20 Apr
    • Re: How to initiate a prog. via mysqlDaniel da Veiga20 Apr