chicago123 Posted March 11, 2014 Share Posted March 11, 2014 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! Quote Link to comment https://forums.phpfreaks.com/topic/286870-how-do-i-reset-a-column-in-a-table-in-my-database-every-x-days/ Share on other sites More sharing options...
Solution jairathnem Posted March 11, 2014 Solution Share Posted March 11, 2014 check : https://www.setcronjob.com They have a free service with upto 50 cron jobs/day. Quote Link to comment https://forums.phpfreaks.com/topic/286870-how-do-i-reset-a-column-in-a-table-in-my-database-every-x-days/#findComment-1472117 Share on other sites More sharing options...
chicago123 Posted March 11, 2014 Author Share Posted March 11, 2014 Ok thanks, that works! Quote Link to comment https://forums.phpfreaks.com/topic/286870-how-do-i-reset-a-column-in-a-table-in-my-database-every-x-days/#findComment-1472242 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.