2. PHPRunner General questions
  3. Edit first table and update in second table
This topic is locked

Edit first table and update in second table

 		7/6/2011 3:07:44 AM
PHPRunner General questions
M
 maxcolo author

Hello everyone,"date"I ask for help for a problem, I have a table called "date" that added to the database after a copy of the record in a table called the support "avute"Now I wish that when I edit a record in the table on a "date" will change also takes place on the second table using an update event Add Before, what is the code to do this?The tables are practically identical:
Table "date"
id_date

nome

cognome

tel
Table "avute"
id_avute

nome

cognome

tel
I would like to modify a record in the first table and automatically change the record on its secont table.I apologize for some mistakes, but I'm an Italian user.Thank you aid and are happy to work with this fantastic program.

thanks
P
 		procheck 7/6/2011

Have you looked at the Actions screen (Insert a record into another table)? Will this not work?
M
 		maxcolo author 7/7/2011

Thank you for reply,

but honestly I can not understand what you mean. I do not want to save the record in the second table, I've already done.

I would like to edit a record on the first table and a new action in the Edit Before I go to change the record on the second table.

I hope that I explained

Best wishes
A
 		Aleix 7/7/2011



Thank you for reply,

but honestly I can not understand what you mean. I do not want to save the record in the second table, I've already done.

I would like to edit a record on the first table and a new action in the Edit Before I go to change the record on the second table.

I hope that I explained

Best wishes


Hi Maxolo;
You can try this:
1.- In the EDIT event page in the firts table.

Before update, you can read the fields with

$value = $values ("MyFieldName");
2.- With this information do a sql to read information in the second table
3.- Edit the information and record.
Is it that do you want? I hope yes, in another way tell me
Bye