My foreach in an array login wrong to send emails with items in array

If you have some time to help me with this:

I am trying to get emails to be sent with items in an array that pertain to that email address only. In Line 226 you'll see my attempted code. If it works, then I change line 290 to $itemNames (notice the plural), to list those items. But I need help with Logic. I would like, instead of emails sent each time per one item (in the iteration), to send all items in one email per client email only.

I've attached the file.

lines 233-247 should probably be something like:

<?php

$itemNames = "";

$wa_startindex = 0;

while(!$WADAecart_items_placed_in_cart5->atEnd()) {

  $wa_startindex = $WADAecart_items_placed_in_cart5->Index;

?>        

      <?php  

    $itemNames .=  "<p> - " . $WADAecart_items_placed_in_cart5->getColumnVal("DetailItemName") . "</p>";       

    ?>

         <?php

  $WADAecart_items_placed_in_cart5->moveNext();

}

$WADAecart_items_placed_in_cart5->moveFirst(); //return RS to first record

unset($wa_startindex);

unset($wa_repeatcount);

?>

I have that happening already on line 265. What I want is the email sent to have all the items that client placed in the cart instead of one item in several emails. Here's what I get


Hello,

Thank you for your interest in DDD. We wanted to remind you about some products you placed in your cart on 8/20/2021.

- 3" COR-LOK®-B2-PTV Air Chuck with 1.25" Diameter bore

If you need assistance or have questions regarding this product, please contact us . You may also go to your cart to finish checking out by clicking here.

Have a wonderful day!

Sincerely,


and in a separate email, I get the other item.


But I want both items in one email. So I am trying to get:

Hello,

Thank you for your interest in DDD. We wanted to remind you about some products you placed in your cart on 8/20/2021.

- 3" COR-LOK®-B2-PTV Air Chuck with 1.25" Diameter bore
- 9" Adjusta-Pull Rubber Roller

If you need assistance or have questions regarding this product, please contact us . You may also go to your cart to finish checking out by clicking here.

Have a wonderful day!

Sincerely,


Thanks

Update line 259 from:
$OrderEmail = $WADAecart_items_placed_in_cart4->getColumnVal("OrderEmail");
to:
$OrderEmail = $itemsplacedincartemail3xx3;

Then remove the loop around the email (code currently on lines: 252-256 and lines: 318-323

Then replace your code above (lines 233-247) with mine from above.

Delete these other lines:
<?php
echo "<h3>" . "Email Address: " . $OrderEmail . "</h3>";
echo $WADAecart_items_placed_in_cart4->getColumnVal("DetailItemName") . "<br>";
$itemNamex = $WADAecart_items_placed_in_cart4->getColumnVal("DetailItemName");
$itemName = str_replace(chr(194),"",$itemNamex); //USE IF USING UTF-8 FOR PAGE ENCODING
?>

Update your message to use $itemNames

-------------------------------------------------------------

Once you have done all of that, if it still doesn't work, attach the updated file so I can look at it with a description of the result in a reply to this thread.

Yeah, that works now.

I appreciate your help. Thank you!