MX Shop Forum :: Order Email Loop?

Hello,

I have followed the instructions from the "Customizing MX Shop PHP" manual and on Page 50 it says to replace this code in the send email trigger:

$emailObj->setContent("Product: {rsOrderDetails.pname_ode}\n\\nPrice:{rsOrderDetails.pprice_ode}\n\\nQuantity: {rsOrderDetails.pquantity_ode}\n\\nProperties: {rsOrderDetails.pproperties_ode}\n");

with this code:

$rsOrderDetails = $GLOBALS['rsOrderDetails'];

$row_rsOrderDetails = $GLOBALS['row_rsOrderDetails'];$message="";

do {$message.= "Name: ".$row_rsOrderDetails['pname_ode']."\nProperties:".$row_rsOrderDetails['pproperties_ode']."\nPrice: ".$row_rsOrderDetails['pprice_ode']."\nQuantity: ".$row_rsOrderDetails['pquantity_ode']."\n\n";}while($row_rsOrderDetails = mysql_fetch_assoc($rsOrderDetails));$emailObj->setContent($message);

The code works fine to loop the product information.  But I would also like to enter information before and after the product loop for each order email.  I would like this information before and after the product loop to be static and NOT loop each time the product info does.  Can you please tell me what I need to add to code to do this?

I am sorry I am packing in all of my support questions, but I know the deadline for MX Shop questions are Tomorrow and I have a store I am trying to have completed by June 1st.

Thank you guys for all of your help so far.......

Sirian

Hi,

I am not sure I understand the problem - but if you want the message to include some other info outside the loop, you can do like:

$message .= "details here";

do {

//this is the loop

.....

while (...);

$message .= "other details here";

$emailObj->setContent($message);

Ionut

That worked great, thanks Ionut......