algebraic equations and mysql

[LadyDivine]

For obvious reasons (game exploiting) in the game we are building we cannot use the php arithmetic.

We are attempting to add these two equations in a mysql form

$a / 1000 + $b = $c
$c / 1000 + $d = $e

We have spent half the night researching and attempting to figure out how to do so. This is our final attempt before making an extra column in our database table which is the last thing we want to do.

The whole thing is coverting game money.

$a = gold
$b = silver
$d = copper

We only have one column with the copper making it easier for players to convert their money when purchasing.

We know in php it's possible, but it's easy to duplicate money that way.

Any ideas on what we can do to fix this?

 

[TonyGroves]

It's not very clear what you are trying to do here. What columns do you have in the table, and what results do you want the query to return?