2. PHPRunner General questions
  3. Calculations
This topic is locked

Calculations

 		11/12/2007 05:05:08
PHPRunner General questions
M
 michael.dejong author

Hi.
I like to calculate two values in the Db and show the result.

This is the string today

Längd X

Bredd    {$row.1L_ngd_value} X {$row.1Bredd_value} =__
What shall I do ?

Michael <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=6791&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />
Alexey admin 11/12/2007

Michael,
the easiest way to do this is to add a calculated fiedl to your SQL query.

I.e.

select

...

*L_ngd Bredd as Mul**

from ...



You can modify the query on Edit SQL query tab in PHPRunner
C
 		crespowu 11/13/2007

You can modify the query on Edit SQL query tab in PHPRunner
Can you tell me the detailed process?
iPod Software makes ipod more fantastic.

iPod Video Converter can rip dvd movies to ipod.
J
 		Jane 11/13/2007

Hi,
proceed to the Edit SQL query tab in the PHPRunner, check off Edit SQL query manually option and edit your query.

Here is a sample:

select field1,

field2,

...

L_ngd,

Bredd,

L_ngd * Bredd as Mul

from TableName
M
 		michael.dejong author 11/14/2007

Thank you all, but I am running ASPRunnerPro 5.1. So how do I do it in ASP?
Alexey admin 11/14/2007

Exactly the same way.