Database Trigger

[eluser]Unknown[/eluser]
Hi everyone!

I'm doing a messaging module for my CodeIgniter website.

But I have a problem.

How will I be able to update the number of messages for a current user dynamically every time a user would message him or her?

I'm thinking of having a database trigger, but I don't know how will I work on it.

Thanks!