Question by Justin M: How can i run a php or mysql script automatically every month, quarter or year?
I have a script for a MySQL Database that adds up all of the numbers in a column and sets it back to zero (its pretty much like an adjusting entry). I don’t want to clear the contents completely because I need them for reporting purposes. I want either PHP or MySQL to run a script to do this automatically so I don’t forget to do it. What is the best way in going about doing this?
Answer by Rahul Arora
Have you hosted this on a Linux cPanel Server.. If es.. then you might have heard of Cron Jobs.. Cron jobs are scheduled tasks that take place at predefined times or intervals on the server.. This feature is available on cPanel servers.. Check the below link for details :
Know better? Leave your own answer in the comments!