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!
How do I reset a column in my database every x days?
Moderator: General Moderators
-
chicago123
- Forum Newbie
- Posts: 5
- Joined: Sat Mar 08, 2014 10:24 pm
Re: How do I reset a column in my database every x days?
Schedule a cron job somewhere else. Write the script that will update your DB then call it via cURL or something from somewhere that does support cron or similar.
-
chicago123
- Forum Newbie
- Posts: 5
- Joined: Sat Mar 08, 2014 10:24 pm
Re: How do I reset a column in my database every x days?
Ok thanks, that worked!
-
Kathleen201
- Forum Newbie
- Posts: 1
- Joined: Wed Apr 02, 2014 9:52 am
Re: How do I reset a column in my database every x days?
If your hosting provider doesn't allow setting cronjobs, there are some services, that will allow cronjob up to for free, like easycron.com.