[SOLVED] MySQL subtract Add to table columns for one value

[$username]

Hello All,

    So I have 2 Columns in my table Total and Paid

 

I want to subbtract them so that it will tell me the total. These will have more then one value in the rows

 

Total    Paid

100        50

200        25

300        10

-------------

600    -  85  =  515

 

Is there a mysql way or a PHP way of doing this?

 

Thanks

Brett

 

[$username]

So I got it by doing something like this

 

while($row532 = mysql_fetch_array($sql532)) {

$TotalAmountOwed += $row532['BillingAmount'] - $row532['BillingAmountPaid'];

 

}

 

Thanks

Brett