如何计算PHP中变量的总和

Question

It calculates, but starting from the second row.

<?php
include('connect-db.php');
$query = "select * from users";
$result = mysql_query($query); 
$row = mysql_fetch_array($result);
$sold= array();

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { 
  $sold=$row['contract']+$row['tva'];
  echo "<table><tr><td>" . $sold. "</td></tr></table>";
}
?>

Answer 1

Since you already extracted a row from the result, with $row = mysql_fetch_array($result);, the script starts adding only with the next row. Th correct code would be:

 <?php
     include('connect-db.php');
    $query = "select * from users";
    $result = mysql_query($query); 
    $sold= array();

    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { 
    $sold=$row['contract']+$row['tva'];
    echo "<table><tr>
    <td>" . $sold. "</td>
    </tr></table>";
    }
        ?>