2. PHPRunner General questions
  3. selecting records in beforeadd
This topic is locked

selecting records in beforeadd

 		5/3/2007 4:43:25 AM
PHPRunner General questions
K
 karen price author

Hi,
If I have the following records:
foyer_model

foyer_uom

foyer_price

foyer_qty

foyer_amt
How can I select foyer_price and multiply it by foyer_qty to obtain foyer_amt to be saved in the database.
Thank you.
Alexey admin 5/4/2007

Hi,
use this code in Before record added event:

$values["foyer_amt"]=$values["foyer_price"] * $values["foyer_qty"];
K
 		karen price author 5/6/2007

Thanks for your help.
Figured that out <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=17648&image=1&table=forumreplies' class='bbc_emoticon' alt=':lol:' />

Hi,

use this code in Before record added event: