I have a problem on breaking down the amount of the given payment, I think i was missing something on my code. This is my table below.

If i have payment of 5,000, it will deduct on the first row and the remaining sum will send to the 2nd row.

//this is the payment

```
$payment = 5000;
$temp = '';
```

//the loop of function

```
$data = payment_breakdown();
foreach ($data as $row) {
$amount = $row['AMOUNT'] - $payment."\n";
}
```

//handle the difference of every loop of the function

```
$temp = $amount;
```

//result of the amount

```
echo $amount;
```

//this is my function to get the data from the table

```
function payment_breakdown(){
$db = database2();
$query = "SELECT AMOUNT FROM TABLE1";
$cmd = $db->prepare($query);
$cmd->execute();
$rows = $cmd->fetchAll();
$db = null;
return $rows;
}
```

supposedly if the amount on the table is this

```
Data From Table | The Payment
3000 | 3000
3000 | 2000
```