I use PHP and MySQL create the program to retrieve data from the table of grants in webpage:
The table with the data of all grants, I want to calculate the result of the used grant by subtracting the amount of expanses each time used. for example:
Balance
50000
400
6000
300
------------------
result $43300
Please help me get the way to retrieve the result each time submitted. Thank you!
The table with the data of all grants, I want to calculate the result of the used grant by subtracting the amount of expanses each time used. for example:
Balance
50000
400
6000
300
------------------
result $43300
Please help me get the way to retrieve the result each time submitted. Thank you!