getting the sum

[stevenrhiggins]

I'm trying to get the sum of an "array".

while ($row=mysql_fetch_array($result)) {
$numpins=$row["counter"];
$due=(($retail/$decrement)($resell$numpins));
$amount_due=round($due,2);

In this case I want to get a sum for $amount_due which is a total for each record.

Thanks in advance.

[[deleted]]

$iTotal = 0;
while ....
{
  $iTotal +=$row['counter'];
};

[stevenrhiggins]

Thanks but I still can't get it to work.

Here is some additional code:
//result 2 gets distinct records
while ($row=mysql_fetch_array($result2)) {
$pin_batchid=$row["batchid"];
$retail=$row["pinvalue"];
$decrement=$row["decrement"];
$resell=$row["resell"];

//get the total number of pins activated within each batch
$result3=mysql_query("SELECT COUNT(username) as counter FROM pins WHERE batchid='$pin_batchid'AND (pins.firstlogin>='$datefrom' AND firstlogin<='$dateto') AND currency='$currency'");

while ($row=mysql_fetch_array($result3)) {
$numpins=$row["counter"];
$due=(($retail/$decrement)($resell$numpins));
$amount_due=round($due,2);
}
Now I need to sum the $amount_due for each record.

Is that any clearer? or perhaps you don't need clarification and I do. 🙂

[[deleted]]

something like this I think:
//result&nbsp;2&nbsp;gets&nbsp;distinct&nbsp;records&nbsp;
while&nbsp;($row=mysql_fetch_array($result2))
{&nbsp;
&nbsp;&nbsp;$pin_batchid&nbsp;=&nbsp;$row["batchid"];&nbsp;
&nbsp;&nbsp;$retail&nbsp;=&nbsp;$row["pinvalue"];&nbsp;
&nbsp;&nbsp;$decrement&nbsp;=&nbsp;$row["decrement"];&nbsp;
&nbsp;&nbsp;$resell&nbsp;=&nbsp;$row["resell"];&nbsp;

&nbsp;&nbsp;//get&nbsp;the&nbsp;total&nbsp;number&nbsp;of&nbsp;pins&nbsp;activated&nbsp;within&nbsp;each&nbsp;batch&nbsp;
&nbsp;&nbsp;$result3&nbsp;=&nbsp;mysql_query("SELECT&nbsp;COUNT(username)&nbsp;as&nbsp;counter&nbsp;FROM&nbsp;pins&nbsp;WHERE&nbsp;batchid='$pin_batchid'&nbsp;AND&nbsp;(pins.firstlogin>='$datefrom'&nbsp;AND&nbsp;firstlogin<='$dateto')&nbsp;AND&nbsp;currency='$currency'");&nbsp;

&nbsp;&nbsp;////&nbsp;reset&nbsp;the&nbsp;total
&nbsp;&nbsp;$iTotal_due&nbsp;=&nbsp;0
&nbsp;&nbsp;while&nbsp;($row=mysql_fetch_array($result3))
&nbsp;&nbsp;{&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;$numpins&nbsp;=&nbsp;$row["counter"];&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;$due&nbsp;=&nbsp;(($retail/$decrement)($resell$numpins));&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;$amount_due&nbsp;=&nbsp;round($due,2);&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;$iTotal_Due&nbsp;+=$amount_due;
&nbsp;&nbsp;};
&nbsp;&nbsp;echo&nbsp;$iTotal_Due;
};

[stevenrhiggins]

That did the trick Vincent. Thanks!