Thanks for answering my question I understand rounding now.
My next question is why the script will work like this:
$bank_points= $ret;
$interest = .095;
$months = 12;
$weeks = 52;
$days=365;
$query="SELECT bank_points FROM wt_users WHERE uid={$session["uid"]}";
$ret = mysql_query($query);
while(list($bank_points)=
mysql_fetch_row($ret))
$yearly_interest=$bank_points * $interest;
$round_yearly= round($yearly_interest);
print("<BR>Your yearly interest is : $round_yearly Gold Pieces");
$daily_interest=$round_yearly / $days;
$round_daily = round($daily_interest);
print("<BR>Your daily interest is : $round_daily Gold Pieces");
$query = "UPDATE wt_users set bank_points = bank_points + $round_daily WHERE
uid={$session["uid"]}";
$result = mysql_query($query);
and not like this.
$bank_points = $ret;
$interest = .095;
$months = 12;
$weeks = 52;
$days=365;
$yearly_interest=$bank_points * $interest;
$round_yearly= round($yearly_interest);
$daily_interest=$round_yearly / $days;
$round_daily = round($daily_interest);
$query = "UPDATE wt_users set bank_points = bank_points + $round_daily";
$ret = mysql_query($query);
or this.
$query = "UPDATE wt_users set bank_points = bank_points + $round_daily";
$ret = mysql_query($query);
$bank_points = $ret;
$interest = .095;
$months = 12;
$weeks = 52;
$days=365;
$yearly_interest=$bank_points * $interest;
$round_yearly= round($yearly_interest);
$daily_interest=$round_yearly / $days;
$round_daily = round($daily_interest);
$query = "UPDATE wt_users set bank_points = bank_points + $round_daily";
$ret = mysql_query($query);
If I use the users session id then it works fine. With the query all I'm doing is
updating ALL users bank_points right? I want to use cron to update all users at
midnight.
Thanks again
Jennifer Downey
