Ray, I need some help, look all over the web but I think you might be able to help me. I'm not a coder so I'm sure a coder can do this with ease.
On detail page can math be applied when the page opens? I need to take one field, subtract another field to fill in that value into third field.
The example below is from the a detail page. I would like to take Day1_ScaleWeight - (subtact) Day1_Penalty to fill in Day1_TotalWeight.in the mysql table. Seems this would be page to do the math on as once this two data fields are inserted or updated the detail page could be used to run a calculation like this.
<?php
$WADADirResD_details = new WA_MySQLi_RS("WADADirResD_details",$ABANet,1);
$WADADirResD_details->setQuery("SELECT id, Division, Location, Date, Name, MemberID, BigBass, BigBassFee, Place, DQ, Day1_Fish, Day1_Alive, Day1_Short, Day1_Penalty, Day1_BigBass, Day1_ScaleWeight, Day1_TotalWeight, Points, Payout, Payout_Description FROM DirResD WHERE id = ?");
$WADADirResD_details->bindParam("i", "".($_GET['id']) ."", "-1"); //Paramid
$WADADirResD_details->execute();
?>
Thanks in advance!