.. division problem

TeriyakiDelight

<?php	 
if (!$submit)
{

           ?>
		    <table width="80%"  border="0" cellpadding="5" cellspacing="1" bgcolor="#D5D5D5">
             <form method="post" action="<?=$PHP_SELF?>">
	          <tr>
               <td bgcolor="#FFFFFF"><div align="left">Money Earned:<br>              
		       $<input type="text" name="moneyearned" class="input_verdana2" value="">
                <input type="Submit" name="submit" value="Submit">
               </div></td>
              </tr></form>
            </table>
            <?

}
else
{
		 	$query = "SELECT sum(balance) as balances, sum(refearnings) as refearns FROM vbPTS_Members WHERE accountstatus = '1';";
			$result = @mysql_query($query);
			$row = @mysql_fetch_array($result);
			$totaltokens = number_format(($row[balances]+$row[refearns]), 2, '.', ',');

		$total = ($moneyearned /$totaltokens);

		$query = "UPDATE moneyearned SET moneypt = '$total' WHERE id = '1';";	
					@mysql_query($query);
	 echo "Total per token: $total <br>Total Tokens: $totaltokens<br>Money Earned: $moneyearned<br>";
	 echo "Updated Successfully";
}
?>

What's showing up in the database is 1.397___
Obviously that's not what $moneyearned /$totaltokens should equal

Should be something like .0013737____

Any ideas? Thank you in advance for posting.

Weedpacket

It's not obvious at all, because no-one here knows what $moneyearned and $totaltokens are, so their ratio could be anything, including 1.397.

What can be said is that you don't want to go formatting $totaltokens as a string with rounding, commas and so on; you want to leave it as a number.

I don't know if MySQL is up to it, but you might be able to do everything (the select, the division, and the update) with a single query. I'm pretty sure you could write "SELECT sum(balances)+sum(refearnings) as totaltokens" at least.

TeriyakiDelight

woops - you're completely right. When I was asked about this problem I was in the same situation you're in.

$moneyearned was $400
$total tokens was 351,688.00