[RESOLVED] Adding values of an array

[anoopd]

Hello,

   Here is the problem i am facing.I have a loop displaying a number filed from my db.


                   [code=php]$sql = "select * from amount";
       $query = $DB->Query($sql);
       $count=mysql_num_rows($query);

                   for($i = 0; $i < $count; $i++)
                      {
                        $j=$i+1;
                         $item = mysql_fetch_assoc($query);
                       echo "<table><tr><td align=center>".$j."</td>";
                     echo"<td align=center>".$item['bsal']." </td>";
                     echo"<td align=center>".$item['ta']." </td></tr></table>";

                    }[/code]

I just want to insert two colums with one showing the sum of these values (bsal+ta) and the other showing the persentage of bsal (bsal/total(bsal)) but i dont know how to do that.The problem is that i dont know how to deal with values in arrays.Please help and thanks in advance
regards
anoop

[Weedpacket]

First of all, don't select "*" unless you don't know what fields you want. Select the fields you want.

There are two possibilities. First is to use select sum(bsal) to get the total. But that would mean a second query, and the first query gives you all the information you need.

But you can't output the table until you've read all the records - you don't know what the total is until then. So you'll have to read all the records in one loop, and then have a second loop to write out the table.

$sql = "Select bsal, ta from amount";
$query = $DB->Query($sql);
$count = mysql_num_rows($query);
$bsal = array();
$ta = array();
for($i=0; $i<$count; $i++)
{
    list($bsal[], $ta[]) = mysql_fetch_row($query);
}
$bsal_total = array_sum($bsal);
for($i=0; $i<$count; $i++)
{
  echo $bsal[$i], $ta[$i], $bsal[$i]+$ta[$i], $bsal[$i]/$bsal_total, "whatever";
}

[anoopd]

Thanks a lot weedpacket