I was wondering how do you update a calculated field in mysql? Using mysql? Are there any functions that could help you? Or do I have to create one?
Code: Select all
eg:
field 1 value: 10
field 2 value: 5
field 3 value: 15 (field 1 + field 2)
then when i update and change field 2.. value: 8
I would like field 3's value to change..
So now field 3 value should be: 18any comments/ help.. is appreciated
Thanks alot!