foreach Productin repeated results

[feign3]

I have 2 queries. One used as part of an outer loop and the other used in the inner loop.

I am using a foreach to move through the inner loop query values and build the body of an email. However, my results are producing repeating values. It makes sense why (multiple iterations through the foreach) but I don't know the right way to accomplish this.

The below code is meant to retrieve some address information for a customer and then get all order details for that customer in an inner loop.

while($row = mysql_fetch_assoc($CustomerDetails)) {

$body .= "****************************************************************** \n";
$body .= "ORDER # ".$order_count."\n";
$body .= "****************************************************************** \n";

$body .= "NAME: ".$row["title"]." ".$row["first_name"]." ".$row["last_name"]."\n";
$body .= "SHIPPING ADDRESS: ".$row["address_1"]."\n";
	$body .= "SHIPPING ADDRESS 2: ".$row_CustomerDetails["address_2"]."\n";
$body .= "CITY: ".$row["city"]."\n";
$body .= "STATE: ".$row["state"]."\n";
$body .= "ZIP: ".$row["zip"]."\n\n";

while ($row_OrderDetails = mysql_fetch_assoc($OrderDetails)){
	foreach($row_OrderDetails AS $key) {

 	  $body .= "ITEM SKU: ".$key."\n";
	   $body .= "ITEM NAME: ".$key."\n";
	   $body .= "QUANTITY: ".$key."\n";		
	} 
}
}

This code however produces the following output:

ITEM SKU: 10
ITEM NAME: 10
QUANTITY: 10
ITEM SKU: ANTI-AGING FACIAL SERUM
ITEM NAME: ANTI-AGING FACIAL SERUM
QUANTITY: ANTI-AGING FACIAL SERUM
ITEM SKU: 2
ITEM NAME: 2
QUANTITY: 2

What would be the proper way to do this so I achieve this instead:

ITEM SKU: 10
ITEM NAME: ANTI-AGING FACIAL SERUM
QUANTITY: 2

[bpat1434]

With the while() you get an associative array. Use the keys to define what items go on what rows.

while($row_orderDetails = mysql_fetch_assoc($OrderDetails))
{
    $body .= 'ITEM SKU: ' . $row_orderDetails['sku'] . '
ITEM NAME: ' . $row_orderDetails['name'] . '
QUANTITY: ' . $row_orderDetails['quantity'];
}

Note that the array keys are the column names from mysql (or the names of the columns defined in the SELECT clause of the sql query).

[feign3]

Thanks.

However I was told I had to use a foreach in another forum because I was trying to pass a value from the result in an outer loop to the query in the inner loop.

Here is the original suggestion from someone in another forum:

---

This won't work as

while($row = mysql_fetch_assoc($OrderDetails)) {

can only be defined once.

You should do:

<?php 

$result2 = mysql_fetch_array($OrderDetails);

?>

and then:

<?php

while($row = mysql_fetch_assoc($CustomerDetails)) {

 Pass customer_id from $CustomerDetails query to $OrderDetails in inner loop below

 foreach($result2 AS $key) {

       Use customer_id value to drive this inner query      
 }
}

?>

---

What is the proper way to get this done?

By the way I added the while loop on the inner loop based on something I read somewhere else... the person from the other forum did not suggest that part.

[feign3]

I also notice if I use:

while($row_orderDetails = mysql_fetch_assoc($OrderDetails))

I only get one row from the query. There re 5 rows that should be returned.

[laserlight]

feign3 wrote:

I only get one row from the query. There re 5 rows that should be returned.

That implies that the query is only returning one row.

[feign3]

Your absolutely correct... that was a careless mistake on my part.. I had hard coded a product id for debugging.

Sorry to waste your time.

This brings me back to my original problem that started all of this however... I need to pass a value selected from my outer query to the query in my inner loop.

Can someone guide me on how this would be done?

[feign3]

I assigned the value from the outer loop to a session variable and made it available for use in the inner loop that way.

Is this the right way to do it or is there a better method?