[SOLVED] Lost .. take from one give to another

[ViciousC]

Basically

 

C=A+B

If A=5 and B=5 then C=10.

 

After C=10 then I want A=0 and B dont change.

 

Trying to update the database wont let A=0 at the same time A=5

 

 

[rajivgonsalves]

what is the update statement ?

[ViciousC]

Kinda got this I know its wrong by far:

 

$newamount = $userrow["case"] + $userrow["i14"];

$newamount2 = $userrow["i14"]-0;

 

$updatequery = doquery("UPDATE {{table}} SET case='$newamount', i14='$newamount2' WHERE id='".$userrow["id"]."' LIMIT 1", "users");

[rajivgonsalves]

can't make sense of your code but whats "-0" that will not do anything at all

 

[btherl]

"-0" will cast a value to an integer.  In this case I don't see any need to do that..

[ViciousC]

Wrote it wrong sorry

 

$newamount = $userrow["case"] + $userrow["i14"];

$newamount2 = $userrow["i14"] - $newamount;

 

$updatequery = doquery("UPDATE {{table}} SET case='$newamount', i14='$newamount2' WHERE id='".$userrow["id"]."' LIMIT 1", "users");

[ViciousC]

Nevermind once i fixed my typo it wroks fine. Thanks anyway