I want to add a number of fields together to send as a total to gateway. Unfortunately the client may leave fields blank which are entered as NULLs which can not be added!
SELECT gener_amt_don + area_amt_don + region_amt_don + prog_amt_don + other_amt_don +disast_amt_don AS total, id_don, user_don, repeat_don, gener_don, gener_amt_don, area_don, area_amt_don, region_don, region_amt_don, prog_don, prog_amt_don, repeat_don
I need to be adding numbers for "total" to have a value.
The form which inserts has fields,(amounts (amt_x)), which are not populated. I would think that the script below would enter the default 0.00. But it is entering NULL which you can not be add to total.