从特定行获取求和值

Question

I have this:

$result = mysqli_query($mysqli, "SELECT balance FROM " . MYSQLBTCTABLE . " WHERE address='" . $_POST['address'] . "' LIMIT 1");
while($row = mysqli_fetch_assoc($result)) {
    $balance = $row['balance'];

echo "<font style='font-weight:bold;'>Your current balance is: </font><br/>";
printf("%0.8f", ($balance / 100000000));

but it gets only the last value I need to find all balances from that address and sum them in total for the $balance.

Answer 1

Remove limit 1 and do the sum

        $result = mysqli_query($mysqli, "SELECT balance FROM " . MYSQLBTCTABLE . " WHERE      
        address='" . $_POST['address'] . "' ");
        $balance = 0;
        while($row = mysqli_fetch_assoc($result)) {
           $balance += $row['balance'];
        echo "<font style='font-weight:bold;'>Your current balance is: </font><br/>";
        printf("%0.8f", ($balance / 100000000));