How do I reset a column in a table in my database every x days?

[chicago123]

I am a PHP beginner.

 

Every x days (every 7 days for example), I would like all the values in a certain column in my MySQL database to reset back to '1'. How do I do this?

 

Please note: My web host does NOT have the MySQL event scheduler enabled  so that is not an option. Also, my web hosting plan does not allow me to do cronjobs so that is not option either. Any other ideas?

Thanks!

[jairathnem]

check : https://www.setcronjob.com

 

They have a free service with upto 50 cron jobs/day.

[chicago123]

Ok thanks, that works!