Trying to send a complicated email

Hi,

I've used UE4 many times and always with success. This time however I'm trying to send an email that lists Coupon Codes to members.

The rsAllCurrentOffers recordset is just a simple one to begin with as I list all the fields. The name of the organisation where they spend

the Coupon though is a Forein Key in the record set.

So far so good the email is sent but obviously the name of the organisation (a local shop) is just a number. When I link the two database

tables together, that's when I get the problem. The record set works correctly when tested but the email is not sent and a load of error

warnings are displayed. I list the errors below and attach the zip of the UE email files.

Your help would be appreciated as I've spent the last 8 hours trying to solve this and I can't. I'm baffled.

I will also want to add a repeat region once this part is sorted. Will that also cause problems?

Many thanks.

Warning: fopen() [function.fopen]: Filename cannot be empty in /home/walthatc/public_html/webassist/email/mailformatting_php.php on line 128

Warning: fread(): supplied argument is not a valid stream resource in /home/walthatc/public_html/webassist/email/mailformatting_php.php on

line 129

Warning: fclose(): supplied argument is not a valid stream resource in /home/walthatc/public_html/webassist/email/mailformatting_php.php on

line 130

Notice: Undefined offset: 0 in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 83

Notice: Undefined offset: 0 in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 85

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at

/home/walthatc/public_html/webassist/email/mailformatting_php.php:128) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on

line 133

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at

/home/walthatc/public_html/webassist/email/mailformatting_php.php:128) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on

line 133

Warning: Cannot modify header information - headers already sent by (output started at

/home/walthatc/public_html/webassist/email/mailformatting_php.php:128) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on

line 135

this is an issue a few people are having when using a recordset loop for the to address.

to fix the issue, edit line 68 - 70 of the wasp_newsletter.php page:

$CurIndex = sizeof($RecipArray);
  $RecipArray[$CurIndex] = EmailArrayFromFile("WADAwasp_residents.waspEmail");
  $TotalEmails += sizeof($RecipArray[$CurIndex]);

to:

$CurIndex = sizeof($RecipArray);
  $RecipArray[$CurIndex] = array();
  $RecipArray[$CurIndex][] = $row_WADAwasp_residents;
  $RecipArray[$CurIndex][] = $WADAwasp_residents;
  $RecipArray[$CurIndex][] = "WADAwasp_residents.waspEmail";
 $TotalEmails += mysql_num_rows(WADAwasp_residents);

Many thanks for the reply Jason, it's good of you to take a look.

It's late here in the UK now and I'm out of the office tomorrow but I will give this a go as soon as I can.

you're welcome.

Hi Jason,

I've now tested this and it failed to work I'm afraid.

I'm now getting these errors:

Notice: Use of undefined constant WADAwasp_residents - assumed 'WADAwasp_residents' in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 73

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 73

Notice: Undefined index: WADAwasp_residents.waspEmail in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 93

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Notice: Undefined index: waue_wasp_newsletter_1_Error in /home/walthatc/public_html/webassist/email/mail_php.php on line 297

Notice: Undefined index: WADAwasp_residents.waspEmail in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 93

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Notice: Undefined index: waue_wasp_newsletter_1_Error in /home/walthatc/public_html/webassist/email/mail_php.php on line 297

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 136

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 136

Warning: Cannot modify header information - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 138

I also tried adding the apostrophes to 'WADAwasp_residents'. This gave these error messages:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 73

Notice: Undefined index: WADAwasp_residents.waspEmail in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 93

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Notice: Undefined index: waue_wasp_newsletter_1_Error in /home/walthatc/public_html/webassist/email/mail_php.php on line 297

Notice: Undefined index: WADAwasp_residents.waspEmail in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 93

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Notice: Undefined index: waue_wasp_newsletter_1_Error in /home/walthatc/public_html/webassist/email/mail_php.php on line 297

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 136

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 136

Warning: Cannot modify header information - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 138

please send the latest copy of your page.

Hi Jason,

Latest page attached. The remaining pages have not been touched

line 73:
$TotalEmails += mysql_num_rows('WADAwasp_residents');


should be:
$TotalEmails += mysql_num_rows($WADAwasp_residents);

Hi Jason,

Sorry, I thought I had explained. I tried it as just (WADAwasp_residents) and got errors so I tried it again as ('WADAwasp_residents') but still got errors.

Below is the errors without the apostophes. (WADAwasp_residents). I have just tried it again just to make sure. I've attached the file again for your convenience - as $TotalEmails += mysql_num_rows('WADAwasp_residents');


Notice: Use of undefined constant WADAwasp_residents - assumed 'WADAwasp_residents' in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 73

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 73

Notice: Undefined index: WADAwasp_residents.waspEmail in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 93

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Notice: Undefined index: waue_wasp_newsletter_1_Error in /home/walthatc/public_html/webassist/email/mail_php.php on line 297

Notice: Undefined index: WADAwasp_residents.waspEmail in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 93

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 106

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/webassist/email/mail_php.php on line 274

Notice: Undefined index: waue_wasp_newsletter_1_Error in /home/walthatc/public_html/webassist/email/mail_php.php on line 297

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 136

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 136

Warning: Cannot modify header information - headers already sent by (output started at /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php:73) in /home/walthatc/public_html/admin/wasp_offers/wasp_newsletter.php on line 138