so you're basically saying that you think mysql has triggers (it has, I have been using mysql triggers at least 5-6 years ago), but still say that triggers are only a possible approach if the OP was not using mysql?
Ooops - I first wrote my text thinking MySQL still lacked triggers, but then searched for trigger documentation and found that MySQL 5 has triggers :-/