conditional trigger

[richardko]

Hi,
i have a field called "status" in a mysql table containing orders.
This field records the status of an order. is it possible to create a condition (a trigger of some kind) for this field such that whenever its value changes it records this change to another field.
thanks
ro

 

[audiopro]

How are you changing the 'status' value?


Keith

http://www.studiosoft.co.uk

 

[richardko]

i am updating the status value through php.
thanks

 

[audiopro]

Why not update the other field from within the PHP script, at the same time?

Keith

http://www.studiosoft.co.uk

 

[richardko]

i forgot to mention but there are other clients from connecting to the database and updating it also.

For example, we have a shipping system where the carrier updates the "status".

i could use a php to periodically check the status but i am looking for alternatives.
thanks

 

[audiopro]

If all the transactions are performed using the same script, I would suggest a sub routine which updates the other field each time the 'status' field is altered.
If you are using seperate scripts you may have to call an update script to perform the task.
What is the function of the other field, a last updated date field?

Keith

http://www.studiosoft.co.uk

 

[richardko]

thanks for the reply.
I will probably have to use trigger because there are scripts which connect separately to the table using ODBC. I dont have control over them.
Thanks again