[RESOLVED] Adding inside a loop inside a loop?

[jeepin81]

Hello, I am stumped on how to accomplish this and I'm guessing it might be something easy. I have a loop, inside a loop and in that second loop I need to add the values together to create a total and I need to then display that total in the Parent loop. The problem is, it is doubling my total b/c it is a nested loop.

Any Idea's or thoughts would be appreciated.

$sqlStatment = "SELECT * FROM files.itemmast
				LEFT JOIN files.itempict ON iitem = pitem
				WHERE ico = '1'
				AND imfgno = 'DISC'
				AND iclass = 'ACPLQ'
				AND ivendr <> '980'
				AND iqtyoh > '1'
				";

$stmt = db2_prepare($i5db2, $sqlStatment) 
                    or die("Prepare error: " . db2_stmt_errormsg());

$result = db2_execute($stmt) 
          or die("Execute error: " . db2_stmt_errormsg());

//Get qnty
while ($row = db2_fetch_assoc($stmt)){ 


//query to get correct available qty
$sqlQTY = "SELECT IITEM, IQTYOH, IQTYBO, IQTYRS FROM files.itemmast
				WHERE IITEM = '".$row['IITEM']."'";

$stmt2 = db2_prepare($i5db2, $sqlQTY) 
                    or die("Prepare error: " . db2_stmt_errormsg());

$result2 = db2_execute($stmt2) 
          or die("Execute error: " . db2_stmt_errormsg());


while ($row2 = db2_fetch_assoc($stmt2)){
$OnHand = $row2['IQTYOH'];
$QTY += $OnHand;
}

echo $OnHand;
echo "- ";
echo $row['IITEM'];
echo " - ";
echo "$";
echo $row['ISELL'];
echo " - ";

Thanks in advance!
j

ps: I'm throwing this out there just b/c - I am extremely tired today and I cannot think straight at all. so if this is really easy, I apologize.

[jeepin81]

I posted the wrong code. I am echoing the $QTY variable and not the $OnHand; apologies.

[johanafm]

First off, it's hard to read your code since you don't indent it properly. You also lack a closing }, but I assume it's supposed to come after the last echo.

Also, since you claim that your code isn't working like it should, I'm going to have to assume that $QTY is supposed to be the total for the query inside the outer loop only, and not a grand total. If this assumption is correct, then

while (outer loop) {
	// ...

$QTY = 0;			// Else it will be a running total.
while ($row2 = db2_fetch_assoc($stmt2)){
	$OnHand = $row2['IQTYOH'];
	$QTY += $OnHand;
}
// ...
}

But, if you havn't removed code to get a minimum working example, there is no need to select the columns that you don't use, and you could instead go for an inner query of

$sqlQTY = "SELECT sum(IQTYOH) FROM files.itemmast
                WHERE IITEM = '".$row['IITEM']."'";

[jeepin81]

Thank You johanafm! Your assumption was correct. I added the $QTY variable inside the outer loop and I am no longer getting the running total.

Thank You for your help - i appreciate it.
j