automatically runable script

[phphelp]

hi
i m developing a site in which i m giving users some points which are to be expired after thier expiry period.now i want to make a script which should run automatically after each minute and checks the users point's expirydate and makes the points '0' if expirytime is reached.

can any body help me that how can i make automatically run and give me code.

[seanf]

Moved to a more appropriate forum. See Where should I post my thread? for details

Sean

[melchiorus]

The easiest way is to make a PHP script to run any SQL queries or what have you and then use a cron job to call this file.

Please note, though, that running it every minute could possibly hurt your server's performance, so use it with care.

[dmsuperman]

How about storing the time to start the expiration with the user and the time that it lasts, then when they run it themselves it compares the time that it's supposed to end with the current time, and if it comes up that the current time is > stored time + time limit then change a setting saying that it expired.