email php function repeat region not working

Report · Apr 12, 2013

i have a form that needs to be emailed and it as products attached to it. however i have a repeat region to list all the products but when i email it ithe email only shows the first item on the list.

below is the form set up

//emailer

// Email new tenant information

$to = 'sales@domain.com';// . ',' . '$row_rsOrder["Email"]';

//$to = $row_rsOrder["Email"];

$subject = "Your Order Details";

$message = "

<html>

<head>

<title>Dear ".$row_rsOrder['FirstName'].$row_rsOrder['LastName']." please see your Order Details Below</title>

</head>

<body>

<h2>Your B Order".$row_rsOrder['OrderID']."</h2>

<tr><td>Thank you for shopping below are you details of the order you have recently placed. If you have any questions please contact us

</a>

<td bgcolor='#E9E9E9' class='header1'>Customer Name</td>

<td class='text'>".$row_rsOrder['FirstName'] . $row_rsOrder['LastName']."</td>

<td bgcolor='#E9E9E9' class='header1'>Order ID</td>

<td bgcolor='#E9E9E9' class='text'>".$row_rsOrder['OrderID']."</td>

<td bgcolor='#E9E9E9' class='header1'>Order Status</td>

<td class='text'>".$row_rsOrder['TransactResult']."</td>

</tr>

<td bgcolor='#E9E9E9' class='header1'>Email</td>

<td class='text'>".$row_rsOrder['Email']."</td>

<td bgcolor='#E9E9E9' >Order Date</td>

<td class='text'>".makeDateTime($row_rsOrder['OrderDate'], '%#d %B %Y', true)."</td>

</tr>

<td bgcolor='#E9E9E9' class='header1'>Shipping Address</td>

<td class='text'>".$row_rsOrder['Address']."

".$row_rsOrder['Town']."

".$row_rsOrder['PostCode']."

".$row_rsOrder['Country']."

</td>

<td colspan='2' align='right' valign='bottom'> ORDER TOTAL:".DoFormatCurrency($row_rsOrder['Total'], 2, ',', '.', '£ ', '')."

Shipping:".DoFormatCurrency($row_rsOrder['Shipping'], 2, ',', '.', '£ ', '')."

</td>

</tr>

<td bgcolor='#E9E9E9' class='header1'>Product ID</td>

<td bgcolor='#E9E9E9' class='header1'>Product Description</td>

<td bgcolor='#E9E9E9' >Quantity</td>

<td bgcolor='#E9E9E9' align='right'>Price</td>

</tr>

<?php do { ?>

<td class='text'>".$row_rsOrder['ProductID']."</td>

<td class='text'>".$row_rsOrder['Product'].','.$row_rsOrder['catname']."</td>

<td colspan='2' class='text'>".$row_rsOrder['UnitSize']."</td>

<td>".$row_rsOrder['Quantity']."</td>

<td align='right' class='text'>". DoFormatCurrency($row_rsOrder['UnitPrice'], 2, ',', '.', '£ ', '')."</td>

</tr>

<?php } while ($row_rsOrder = mysql_fetch_assoc($rsOrder)); ?>

</tr>

</table>

</body>

</html>

";

// Always set content-type when sending HTML email

$headers = "MIME-Version: 1.0" . "\r\n";

$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";

$headers .= 'From: company name <email@domain.com>' . "\r\n";

$send = mail($to, $subject, $message, $headers);

Report · Apr 23, 2013

Jonathan Fortis wrote:
let me know how you get on please

I split the products and customer information into two tables and it still works.

The sql query still isn't anywhere near as complex as yours is though.

What we have established is the do-while loop does work if you break out and back into the php again.

What I would do is a test using two simple tables first to get the do-while loop working. Once that is working you have a template. Then its a case of building the sql query.

Report · Apr 23, 2013

yeah, trouble with that this is a live site so might be a bit tricky.

Report · Apr 23, 2013

ok i used your code then changed your SQL for mine and it worked. Thanks so much

the only thing that i am having trouble is i have the order details diplayed on the page that sends the email however if i echo any informatioin out below the email code nothing shows. if i add an echo before the email it shows. its like it is killing the order after the email?

Report · Apr 23, 2013

i added the emailer at the end of the page and now it works thanks for your help

Report · Apr 22, 2013

To enable you to check if your page is sending the full repeat content, put this on your thank you page for force it to print it to the page:

<?php @session_start(); var_dump($_SESSION); ?>

You'll get a load of code, but you will also see what content you are getting such as email addresses, time sent and the contents of the body.

Report · Apr 22, 2013

ok i tried this and got the following

array(2) { ["MM_Username"]=> string(6) "bobby12" ["MM_UserGroup"]=> string(0) "" }

Notice: Undefined variable: message in E:\Domains\b\website\user\htdocs\admin\order-details-sent.php on line 136

line 136 is <td class='text'>".$row_rsOrder['ProductID']."</td>

email php function repeat region not working

1 Correct answer