2. PHPRunner Tips and Tricks
  3. Add values from one table and save them in another table
This topic is locked

Add values from one table and save them in another table

 		12/11/2022 5:51:25 AM
PHPRunner Tips and Tricks
Karlo_from_Germany author

My application has a base table in which data from trips with a sailboat are recorded. Each base table can have any number of daily entries.

In the table of daily entries the sailed miles are recorded.

I want to sum up the miles of all daily entries and display them as a value in the base table.

I have searched thoroughly, but have not yet found an example of such a calculation.

Does anyone have an idea how I can implement something like this?

Thanks in advance

img alt

fhumanes 12/12/2022

Hello,

To do a few days I did an example to another user with something similar to what you ask.

Making updates or insertions in another table is quite simple in Phprunner.

The example of the link is made in phprunner 10.2, but you can open it with later versions.

https://micloud.movistar.es/share/nP0ewqV7jgyTHNzo

Cheers,
fernando