my application i have built which runs on php/mysql i now need a way to have it insert a value into a table every set date.
so, on the isnert form just now they would enter the amount of money the company would receive and which date they were paid for history and tracking.
however i now need a way to have it insert say 1.00 every month on a date specified, so the 1st of every month it would insert into the table so if the get 10 people paying this they get 10 every month.
not sure how this would work if at all and they woudl also need the ability to then stop this, so a stop button in the application which would stop any further payments being inserted.
any thoughts on how this could work? they will never have root access to the database so needs to be done in a form on the site which would then do all the inserts every month.
thanks for your help