I need to do a routine that checks if the end date of a certain event has already passed, ie if the date of the "end" field is less than today's date, it updates the "status" field to "finished".
I'm working with codeigniter 3.0
The sql code I know my problem is to cause this code to be run every day for example at 00:00 every day it would check and change the state. I still do not have code developed from this routine because I do not know how to do it myself