this is the example i have the form with 10 fields.. i have the edit page and external page with events to be applied when the form is open.. in the events page there are functions 1. is before the record is edited 2. after the record is updated. this is the way is working..
field general = general_notes this is a read only field..
field1 = notes1
field2 = notes2
field3 = notes3
field4 = notes4
this is what i have now and is working...
Code: Select all
$general_notes = $value['notes1']." ".$value['notes2']." ".$value['notes3']." ".$value['notes4'];
$sql = "UPDATE vital SET general_notes = '$general_notes' WHERE case_n = '".$value['case']."'";
$res = mysql_query($sql,$conn); Code: Select all
$general_notes = $value['notes1']." ".$value['notes3']." ".$value['notes4']." ".$value['notes2'];