2. PHPRunner General questions
  3. conditional formatting for a specific field
This topic is locked

conditional formatting for a specific field

 		2/9/2020 5:07:54 PM
PHPRunner General questions
P
 PaulM author

During an edit I'm saving the old record to a record into another table and would like to change the text of the old data field (the field inserted into the new table) to red just for the fields that have been updated.
I'm using the before updated event to save the existing data to a new table.
$data["LH_L_id"] = $oldvalues["L_id"];

$data["LH_title"] = $oldvalues["L_title"];

$data["LH_first_name"] = $oldvalues["L_first_name"];

$data["LH_last_name"] = $oldvalues["L_last_name"];
So for instance if the L_title was updated I want the LH_title to be red in the new table and all the others to not be changed
How would I do that?
A
 		acpan 2/9/2020

It is very difficult to understand what you are trying to say when you used old and new to describe

your tables and data/names and switched back and forth.
It seems you are not taking about 2 tables, but actually 1 table, else where is the DB API to copy data to another table? It seems you are copying data between fields within the same table, looking at your event codes, but yet, you mentioned old and new tables.
Figure yourself out what you actually want to do and rephrase it and ask again.
ACP