2. PHPRunner General questions
  3. [SOLVED]  Automatic deletion of a value in a table
This topic is locked
[SOLVED]

 Automatic deletion of a value in a table

 		9/30/2019 17:50:31
PHPRunner General questions
Karlo_from_Germany author

I need some inspiration.
I have a table with 6 columns. (column 1, column 2, column 3, column 4, column 5, column 6)
Normally, columns 1 - 3 are filled with values. Column 6 is also filled, Colums 4 and 5 are empty.
If a value is entered in column 4, the value in column 6 is to be deleted automatically.
How can I do this?
Many thanks in advance
jadachDevClub member 9/30/2019

Try doing an update record after record added or edited.
N
 		Nir Frumer 9/30/2019



Try doing an update record after record added or edited.


in before add and/or before update

if (!empty($values['column4'])) {

$values['column6']="";

}

return true;
Karlo_from_Germany author 10/1/2019



in before add and/or before update

if (!empty($values['column4'])) {

$values['column6']="";

}

return true;



Works perfect, thank you so much!