?
Solved

Dreamweaver Recordset to Array; Loop Array and Perform Calculation

Posted on 2013-06-12
4
Medium Priority
?
622 Views
Last Modified: 2013-07-01
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
Comment
Question by:tweddlewalker
  • 2
3 Comments
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 39240797
You can probably do this directly in the query.  I'll ask a moderator to add it to the MySQL Zone(s)
0
 

Accepted Solution

by:
tweddlewalker earned 0 total points
ID: 39279428
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
 

Author Closing Comment

by:tweddlewalker
ID: 39289432
See above
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
I recently worked on a Wordpress site that utilized the popular ContactForm7 (https://contactform7.com/) plug-in that only sends an email and does not save data. The client wanted the data saved to a custom CRM database. This is my solution.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question