PHP - Loop Though Db Adding Values

Hope someone can help, I am trying to add up all the values of a variable in a PHP while loop and have tried several approaches but none seem to work. Hopefully someone can point out what the correct method is.

I've set up some code to pull the pay rate from a MySQL table, and then calculate that person's earnings based on the amount of time they spend on a particular job. That works fine:

           while ($row = $getrate->fetch_assoc()) {

              $staffrate = $row["Rate"];

              $earnings = ($staffrate/3600) * $jobeventtimeseconds;

              $earningsformatted = number_format($earnings, 2);

           }

However there may be a number of jobs for different people with different rates, so I want to add all of these up and output the total. So for example if I had values of 125.00, 35.50 and 22.75 I want to show 183.25 as the total.

So I tried a few things I found on forums on the subject:

$totalearnings = 0;

foreach($earningsformatted as $key => $value) {

   $totalearnings += $value;

}

echo $totalearnings;

That didn't work so I tried another method that someone suggested:

$total=array($earningsformatted);

echo array_sum($total);

The 2nd method outputted just the last individual value, the 1st method didn't work at all. Does anyone have a working method that can be used to do this?

Thanks

I am trying to get info from a table, add rows in that table, and put the added value back into the table in another field...I want to add field1 and field2 of every row and put the total in the total row.
Heres what the echo gives me

Susan 14

Mary 18

Bob 13

Sam 21

heres the database
mysql> SELECT total_val FROM table;

+-----------+
| total_val |
+-----------+
|        21 |
|        21 |
|        21 |
|        21 |
+-----------+



heres the code....


<?php

require("connection.php");


mysql_select_db("database", $connection);
echo "<br />";

$result = mysql_query("SELECT * FROM table");

while($row = mysql_fetch_array($result))
  {
   
     $values = ($row['field1'] + $row['field2']);
    
    
   
   
   $sql=mysql_query("UPDATE table SET total = '$values'");
   
      
  echo $row['user_name'] . " " . $values;
  echo "<br />";
   
  }

?>

also note that if I put a INT in place of $values - the echo changes to match...why??

PLEASE help...I have been working on this for 2 entire days....

Hey! How've you been? This should be simple but I can't make it work. I have a few database values from a user entry. The page queries the database and I can print them no problem. I want to add them and display the total of these values. I've tried about two dozen ways of doing and I just can't get them to add. Where I have "fee_total" I want it to be the sum of the values "fee+upgrade7+tax". This is the snippet of what I'm working on. I won't attach any of what I have tried because, well, there are too many attempts and nothing worked

    $sql = ("SELECT * FROM Teamregister WHERE pkSoloregisterID=$pkSoloregisterID");
    $query = mysql_query($sql);
    $result = mysql_query($sql);
    $myrow = mysql_fetch_array($result);

    printf ('<form action="https://www.mysite.com/cgi-bin/webscr" method="post">
      <p>Your registration fee is <strong>$%s</strong>.</p>', $myrow['total_fee']);
      echo ("<input type='hidden' name='item_name_1' value='Registration Fee'>");
      printf ('<input type="hidden" name="amount_1" value="%s">', $myrow['total_fee']);
      echo ("<br /><div align='center'>
      <input type='submit'' value='Pay Online'>
      </form>');

Make sense? Like I said, the values are already there but the math isn't happening. To check I tried using individual DB values instead of "total_fee" and the numbers show up. Just cannot get them to add.

hello, i have created a table that desplays perticulars, price per person and number of people. the fees is then calculated by multiplying price per person with number of people. till now everything is good. but the problem is when i try to calculate the total fees.
here is an example to explain you better:
Perticulars Price Per Person Number of people Amount something 10 100 1000 something else 20 100 2000 Total 3000

Code: [Select]
$pert_query = mysql_query ("SELECT * FROM `perticulars` WHERE `invoice` =$invoice") or die(mysql_error());
$i = 1;
$sum = 0 + $_SESSION['sum'];
while($perticulars = mysql_fetch_array($pert_query, MYSQL_ASSOC)) {
?>
<tr>
      <td style="border-collapse: collapse"><div align="center"><?php echo $i;
  $i++; 
   ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['perticulars']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['ppc']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['nop']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center">
        <?php $amount = $perticulars['ppc'] * $perticulars['nop']; echo $amount; $_SESSION['sum'] = $sum+$amount;?>
      </div></td>
    </tr><?php 
} ?>
    <tr>
      <td colspan="4" style="border-collapse: collapse"><div align="center">Total</div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $sum; ?></div></td>
    </tr>
  </table>
From the above code you can see that i am getting the amount form $amount = $perticulars['ppc'] * $perticulars['nop'];
by this each row has its own amount which i got by multiplying the data from mysql.
the problem is how do i find out the Total. i know i am suppose to add up $amount but how?
i even tired using sessions to store the amount and add the new amount to get total but the problem in using sessions is it messes up my next page, no using session is a very bad idea.

I'm telling it to add 1 each time through the while loop but its not and not sure why.

Code: [Select]
<fieldset class="answerLeg">
        <legend>Edit Poll Answers</legend>
        <?php
        $j = 0;
        while($row2 = mysqli_fetch_array ( $pollAnswersResult, MYSQL_ASSOC )) { 
        ?>
            <div class="field required answers">
                <label for="answer<?php echo ($j + 1)?>">Answer #<?php echo ($j + 1)?></label><input type="text" class="text" name="answer<?php echo ($j + 1)?>" id="answer<?php echo ($j + 1)?>" title="Answer <?php echo ($j + 1)?>" value="<?php echo $row2['answer']; ?>"/>
                <span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>     
            </div>
        <?php } ?>
    </fieldset>