[SOLVED] how to add value to a filed every 24 hours?

[berry05]

like when a field is 100 it increases by 50 every 24 hours...any way i can do that?

[premiso]

Use a timestamp column in the database table.

 

IE column named "nextincrease" and set that to be 24hours from now.

 

The next time it is called you would do

 

if nextincrease < time() then add 50 and set nextincrease = time() + (60*60*24);

 

Hope that helps.

 

[berry05]

i made a field called next increase with a timestamp type and entered the code you had and it gave me a error...sorry im kind of new to this..

[trq]

A much more reliable approuch would be to use a cron job to execute a query every 24 hours.

 

Check to see if your hosting supports cron jobs.

[berry05]

cron jobs..ill try that...btw i am the host

[trq]

cron jobs..ill try that...btw i am the host

 

Then you should know what a cron job is (assuming your using Linux).

[berry05]

negative...im using windows..btw can someone make me a cron job that increases the field gold by 50 every 24 hours? xD

[trq]

cron doesn't run on windows. You'll need to use windows scheduler.

[berry05]

thank you!

 

i'll check it out!

[berry05]

one more last thing..is there a php code that if i open it it updates the field and adds 100 so i can do the task manager to open the file every 24 hours so the field gets 100 more every 24 hours?

[trq]

<?php

  // connect to database here.

  mysql_query("UPDATE tbl SET fld = fld+100");

?>

[berry05]

wow how do you know all this!!

thxs man!