[PHPMyEdit-Discuss] question about using triggers

[Thomas <tg...@bi...>]

Hi !

I have the following problem:

I have a table that has a 'date' field. Now I want to update this 'date'=20
field to the actual date/time whenever a change is made to an individual=
 entry.

e.g. I have the following fields in my table:

id
name
city
date


now I want the 'date' field to be automatically updated whenever I make a=20
change to one of the other entries via phpMyEdit.
I guess this can be realized with a 'update_after' trigger.

Could someone maybe show me an example of how this .inc file should look=
 like ?


Thomas G=F6tz

Lehrstuhl f=FCr Humangentik
AG Molekulare Ophtalmologie und Onkologie
Am Hubland
97074 W=FCrzburg
Germany
Tel.: +49 931 888-4094
Email: tg...@bi...=20