Question on MySQL

[JasonReynolds]

Hi, i come here today to ask ask something about MySQL.So, my doubt is about calculations.

I have a table that inside as 2 rows, one row is MAX, the other Remain.

Ok, what i need is that the Remain row subtracts 1 from the MAX. So, if i have in row MAX 10

and in row REMAIN 10, when i click in the software it reduces the value of the row REMAIN to 9 and so on.

 

Im a little blocked there, a little help please.

 

 

So let me get this straight

Row Max has = 10 rows

Row Remain has = 10 rows

But when you run the software the rows are for it reduces remain to 9?

 

(Just for clarification ddnt really understand the post)