2. PHPRunner General questions
  3. [SOLVED]  How i can calculate the total price
This topic is locked
[SOLVED]

 How i can calculate the total price

 		10/17/2020 1:07:02 AM
PHPRunner General questions
J
 Jan author

Hello, I have a table "products" with the following fields:

price, pieces, total price.
In an "inline grid" I can adjust the price and quantity. The Total price must then be recalculated. I can write code in the event "after record updated"
$sql = "Update products set total_price = ???????

where item number = ????????? '";

DB :: Exec ($ sql);
Can anyone help me complete this code?

Thanks in advance
aadham 10/17/2020



Hello, I have a table "products" with the following fields:

price, pieces, total price.
In an "inline grid" I can adjust the price and quantity. The Total price must then be recalculated. I can write code in the event "after record updated"
$sql = "Update products set total_price = ???????

where item number = ????????? '";

DB :: Exec ($ sql);
Can anyone help me complete this code?

Thanks in advance


How to use calculated fields
J
 		Jan author 10/17/2020

Thanks for the helpful tip