desithugg Posted August 3, 2006 Share Posted August 3, 2006 umm is there anyway i can get some Integer rows in mysql to reset (set back to 0) whenever a new day starts? Quote Link to comment Share on other sites More sharing options...
Orio Posted August 3, 2006 Share Posted August 3, 2006 You need to do a cron job for that.You basicly make the script the resets the number, and use a cron to run it every day :)Orio. Quote Link to comment Share on other sites More sharing options...
desithugg Posted August 3, 2006 Author Share Posted August 3, 2006 any sujjestion where to start? Quote Link to comment Share on other sites More sharing options...
Orio Posted August 3, 2006 Share Posted August 3, 2006 First, check if your host supports cron jobs.If it does, make the script and then set a cron job (do you have cpanel, Plesk or something like that?).If your host doesn't support cron jobs, you basicly cant do it.Orio. Quote Link to comment Share on other sites More sharing options...
desithugg Posted August 3, 2006 Author Share Posted August 3, 2006 umm i contacted my host and yes they do support cron jobs.I have made the scriot but what do i name the file.[quote]00 00 * * * /aff/reset.php[/quote] Quote Link to comment Share on other sites More sharing options...
desithugg Posted August 3, 2006 Author Share Posted August 3, 2006 umm i uploaded my file as cron.txt but how can i install it Quote Link to comment 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.