I am a php newbie. I have a problem I just cannot figure out. I have a household income and expense calculator form (inc1, inc2, inc3, exp1, exp2, exp3, exp4)
I need to calculate total income, total expenses, net income, potential savings and the largest expense category with values entered from the form.
My calculations are:
$ttl_inc_val = $_POST['ttl_inc] + $inc1 + $inc2 + $inc3;
$ttl_exp_val = $_POST['ttl_exp + $exp1 + $exp2+ $exp3+ $exp4;
$net_val = $_POST['net'] + $inc1 + $inc2 + $inc3 - $exp1 - $exp2 - $exp3 - $exp4;
$p_svgs_val = $_POST['p_svgs'] + $net + $exp4;
I still haven't figured out the how-to for the largest expense, but my problem at this point is that I cannot get any of these calculations to post to my database tables (6 tables in total-don't ask). I did manage to create a few mysql triggers that will calculate my ttl_inc on the income table and another for the expenses table. But that still leaves the other calculations and all are on different tables. I am sure it is probably something silly that I am missing, but I just cannot see it. Probably been staring at this far too long. Any help would be greatly appreciated.