Repeating region in email body does not work
I have a confirmation email set up to be sent to the customer once an order is placed. The items are provided by a recordset.
My problem is that only the first item shows in the email.
I have put this codeblock in the top of the email template page
<?php
global $row_recordset;
?>
and
<?php do { ?>
<?php echo($row_recordset['columnname']); ?>
<?php } while ($row_recordset = mysql_fetch_assoc($row_recordset)); ?>
in the email body
and
<?php
mysql_free_result($row_recordset);
?>
at the end of the template page.
It sounds like the recordset loop is just not moving to the next record. I have checked the table in my db and the information is stored correctly.
I'm attaching a copy of the email template file.
Regards
Rune