This is a very basic example to calculate subtotal using PHPRUNNER events:
======================================================================================
ProductID....ProductName..........UnitPrice......Qty......Percentage_Discount.....SubTotal
======================================================================================
PROD001......MOUSE................1000,00........2........10,00...............................1800,00
PROD002......KEYBOARD..........2000,00........2........10,00...............................3600,00
======================================================================================
On event use this code :
$values["SubTotal"] = ($values["UnitPrice"] * $values["Qty"]) - (($values["Percentage_Discount"]/100)*($values["UnitPrice"] * $values["Quantity"]));
A forum member also posted how to do this in SQL way :
http://www.asprunner.com/forums/topic/14754-once-again-about-total/
[size="4"][color="#FF0000"][size="5"]Tested on PHPRUNNER 5.2 and MySQL 5.0[/size][/size]
romaldus author