Hello, i'm not sure if this is possible, i can not get the logic or a way to do this using php, i know that pretty much anything can be done with php. heres the problem..
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...
PHP Code:
$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);
ok so this is the thing the order right now is notes1, notes2, and so on... sometimes they only edit notes2 so i need that the notes they edit go to the last place for example if they edit only notes 2 this would be the order
PHP Code:
$general_notes = $value['notes1']." ".$value['notes3']." ".$value['notes4']." ".$value['notes2'];
im not sure how to achieve this, or if its even possible. first i need to know which record is actually being edited.. please help.. thanks |
