Working out remaining balance.

[Exoon]

Hello,

 

Im making a little script to keep track on how much people have currently earnt on my site.

 

I have everything work but i can't figure out how to work out the current balance

 

 

At the moment ive got:

 

$currentbalance = $row['totalpaid'] - $row['points']; 

 

Which works untill the points becomes more then the total paid then it starts going in minus.

 

Im sure there's a simple fix but i just can't think of a way.

 

Any help would be great.

Thanks

[mikesta707]

is the absolute value of that difference the current balance? if so use the abs() function. This takes the absolute value of the input argument.

 

$currentbalance = abs($row['totalpaid'] - $row['points']);

[seanlim]

If it's just a matter of displaying 0 when the $currentbalance drops below 0, use

 

$currentbalance = max($row['totalpaid'] - $row['points'], 0); 

 

But more importantly, why would the points be negative in the first place? Is your calculations correct?

[Exoon]

Im not really sure now ive confused myself.

 

Im trying to show How much has been paid and how is remaining

 

So if they've earnt 5.00 and they request 4.50 i want the current balance to then show 0.50

 

Ive got Points field which contains the total money theyve earnt(including what theyve been paid), and ive got totalpaid which contains the total amount theyve been paid.

[mikesta707]

why don't you reverse the two operands? Seems like you should be subtracting total paid from points, not the other way around. Also, a negative value can make sense assuming you let people "over withdraw" or go into debt