[PHP-DB] Rounding numbers again.

[Jennifer Downey]

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