Im using mysql and This is the entry I have in my current table.

So here ***previous balance*** for current month should be the ***remaining balance*** of previous month. How do I get this value from previous row of database.

```
Previous_balance Remaining_Balance
        0.00        42.64
        0.00        627.69
        0.00        45.54
        0.00        67.60

```

The result should be 

```
Previous_balance Remaining_Balance
        0.00        42.64
        42.64       627.69
        627.69      45.54
        45.54       67.60

```

I have ID as PK and I want store the new previous\_balance in database and print on form. So I can calculate Monthly charges and usage and other stuff. Thanks for answers.