Mysql Scheduling

zaaki_boy

How can I arrange a web site to automatically perform a series of modifications to a mySQL database according to a time schedule? Example: Given that there is a database of user accounts. Every day a specific value in every account is increased by 1. It will not work for what I am doing to simply make the calculations according to the last login time when the user logs in each time. The modifications must actually happen at the set time rate. Any help would be greatly appreciated! Zak

LordShryku

Make the script, set it up in crontab

prycejones

The answer above is the way I would probably do it too.
However - as all things in life -
Here is another thought with regards to your example...
If you only have to increment a value by one each day could you not possibly use a daycount routine.
EG
The column that needs to be incremented could be called count1. It would be a date type.
The initial value posted to count1 would be today's date (possibly).
Then when ever you need to find the value in count1 you could use gregoriantojd.
Here is a snippet for you to see how it works.

$count1=date("2003-10-18");

$yy = date('Y',strtotime($count1));
$mm = date('m',strtotime($count1));
$dd = date('d',strtotime($count1));
$value = gregoriantojd($mm, $dd, $yy);
echo "<BR>".$value;

echo "<BR>".jdtogregorian ($value);

I have put the reverse code in at the bottom for you to check to see that it works.

You dont need to run any daily cron incrementer on this count1 as it will increment itself every day.

QED

HIH

Pryce

pryceATprycejonesDotcom

For more info goto php.net
Here is the page for gregorian date conversion.
http://uk2.php.net/manual/en/function.gregoriantojd.php

zaaki_boy

Thanks for the replies it really is a help....

DOES ANYBODY HAVE AN EXAMPLE OF A SCRIPT THAT IS RUN USING CRON???

LordShryku

Read this for an introduction to crontab. Though, we should probably make sure....is this nix or Windows? Windows doesn't support cron, but you can make a batch file and use task scheduler for that.