Repeat region only working for first sent email
HI,
I am creating a Newsletter - and sending products from a DB... The first email to the first recipient works perfect, but to every other recipient - they get nothing?
HI,
I am creating a Newsletter - and sending products from a DB... The first email to the first recipient works perfect, but to every other recipient - they get nothing?
Hi, I'm fairly new to this plug-in so please forgive me if this is a stupid reply. I believe there is a setting for looping that must be checked (literally) to send emails from a db. It should be in the setup screens for UE. I hope this helps.
Tom
Hi Tim,
No there are no stupid replies :) Appreciate it...
I have the loop set and the record set selected... It is sending emails to the complete Subscribers list...
The issue is the repeat region applied to the products within the email itself... It send say 12 products in then newsletter email for the first subscriber, but all subsequent subscribers do not get the products listed...
I hope that helps to clarify my issse a bit better
Thanks
when using a repeat region, the recordset pointer will be left on the last record after the repeat region finishes the first time, you will need to add code to the email file to reset the recordset pointer after the repeat region finishes.
In the email file, add the following code just before the repeat region:
<?php
mysql_data_seek($rsRecordset, 0);
$row_rsRecordset = mysql_fetch_assoc($rsRecordset);
?>
where rsRecordset is the name of the recordset.
Ahhhhhhh.....Of course!
Perfect!
Thanks
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.