Calc total of dynamic field

[danielb123]

hello, i'm trying to make a sum of the values find in " total3$id" but i'm sure how to do id....

                            <?php
 
                    $query="SELECT * from photo";
$result = mysql_query($query) or die(mysql_error());
$calcTotal = array();
 
while($row = mysql_fetch_array($result))
{
 
$prezzoaccconvirgola=str_replace('.', ',', $row['prezzoacc']);
$balance=$row['piante_pianali'];
$allotment=$row['piante_pianali'];
$total = $balance*$allotment;
$prezzo=$row['prezzoacc'];
$piante_cc=$row['piante_cc'];
$total2 = $allotment*$total;
$id=$row['id'];
$calcTotal[$id] = $total;
$calcTotal2[$id] = $total2;
$calcTotal3[$id] = $total3;
$calcTotal4[$id] = $total4; //stores each calculated total as array element with key of 'id'
echo  "
 
    <input type='hidden' value='$balance' name='balance$id'>
    <input type='hidden' value='$prezzo' name='prezzo$id'>
    <input type='hidden' value='$piante_cc' name='piante_cc$id'>
    <input type='hidden' value='$total3$id' name='total3$id'>
                                        <td>".$row['prodotto']."</td>
                                        <td>".$row['piante_pianali']."</td>
                                        <td>".$row['piante_cc']."</td>
                                        <td>".$prezzoaccconvirgola."</td>
                                    <td><input type='number' name='allotment$id' size=8 onchange='total$id.value = ((allotment$id.value) * (balance$id.value)); total2$id.value = ((((allotment$id.value) * (balance$id.value) * (prezzo$id.value)) * 100 )/100); total3$id.value = (((allotment$id.value) * (balance$id.value)) / (piante_cc$id.value)) ; '></td>
                                    <td><input type='number' value='$ThisTotal' name='total$id' align='right' size=8 readonly></td>
                                    <td><input type='number' name='total2$id' align='right' size=8 readonly></td>
                                    <td><input type='text' class='qty1' name='total3$id' align='right' size=8 readonly></td>
 
                                        </tr>
 
                                            ";
 
                                     }
 
?>
 

[rollerbladegirl]

If I my suggest:

A little bit of basic math examples
https://www.homeandlearn.co.uk/php/php2p6.html

A little bit more than that
https://www.php.net/manual/en/functi...ber-format.php

A little bit of using PHP array_sum() Function
https://www.w3schools.com/Php/func_array_sum.asp

Calculating the sum of values in an array
https://www.php.net/manual/en/function.array-sum.php

I hope that helps.