• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 632
  • Last Modified:

Dreamweaver Recordset to Array; Loop Array and Perform Calculation

We need to create arrays from a Dreamweaver recordset for two fields. In the example below they are listPrice and forexRate1.

We then need to:
- loop through the arrays
- multiplying the two fields together
- calculate the sum and the average of those multiplied fields.

The recordset is:

SELECT prList.listPrice, prForex.forexRate1
FROM (prList
LEFT JOIN prForex ON prForex.forexCode=prList.curr)
WHERE prList.listBrName='".$_SESSION["seldom"]."'
AND prList.listUnitsize='".$_SESSION["selsize"]."'

Is this possible please?
0
tweddlewalker
Asked:
tweddlewalker
  • 2
1 Solution
 
Ray PaseurCommented:
You can probably do this directly in the query.  I'll ask a moderator to add it to the MySQL Zone(s)
0
 
tweddlewalkerAuthor Commented:
I'm new to Experts Exchange. An email tells me I need to take urgent action. Because I have not received suggested solutions, all I can think of doing is closing the question.

Will this do it?
0
 
tweddlewalkerAuthor Commented:
See above
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now