2. PHPRunner General questions
  3. Arithmetic Operators
This topic is locked

Arithmetic Operators

 		4/26/2008 8:22:41 AM
PHPRunner General questions
F
 futo author

i have table:
SELECT

Id_7164,

EUR,

Racun,

Datum,

Izvezeno_kg

FROM `_7164`

ORDER BY Racun DESC
column Izvezeno_kg have total field
I WANT THE NEXT:

  1. TO HAVE ON LIST PAGE CUSTOM INPUT FIELD WITH OPTION TO INPUT NUMBER VALUE ETC. 1.000.000,00
  2. PHP CODE THAT FIELD (1.000.000,00) - Izvezeno_kg(TOTAL FIELD) = RESULT (IN NEW FIELD)
    IS IT POSSIBLE
J
 		Jane 4/28/2008

Hi,
add new field to the table (for number value etc. 1.000.000,00) on the Datasource tables tab, check off Inline Add option on the Choose pages tab.
To calculate result use Before record added event on the Events tab.

Here is a sample:

$values["FieldName"] = $values["NewFieldName"]-$values["Izvezeno_kg"];
F
 		futo author 4/28/2008

manny thanks Jane ill try that