How to change a database field with date?

[shimmerchopra]

I have to change one table value with the date.If the date is passed away then lets say it would contain inactive else active.
And the problem is that I have to do it automatically in my project.Not on any action.
can anyone help me????
Thanks in advance.

[JKing]

Have you taken a look at triggers for mysql?