LCKB
Question on MySQL - Printable Version

+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Programmers Gateway (https://lckb.dev/forum/forumdisplay.php?fid=196)
+---- Forum: Coders Talk (https://lckb.dev/forum/forumdisplay.php?fid=192)
+---- Thread: Question on MySQL (/showthread.php?tid=498)



- CyberClaus - 11-06-2012


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.




- MrBeaN - 11-06-2012

Wrong section. Vote to move this thread in "Request/Help" section.




- Wahrheit - 11-07-2012

no it isnt its general programming and about this his problem is




- JasonReynolds - 01-26-2013


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)