close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Trying to send a complicated email

Thread began 3/29/2011 11:45 am by John Langer | Last modified 4/01/2011 5:01 pm by Jason Byrnes | 1859 views | 18 replies |

John LangerBeta Tester

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

Attached Files
email.zip
wasp_newsletter.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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:

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



to:

php:
$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);
Sign in to reply to this post

John LangerBeta Tester

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.

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

Sign in to reply to this post

John LangerBeta Tester

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

Sign in to reply to this post

John LangerBeta Tester

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

Sign in to reply to this post

Jason ByrnesWebAssist

please send the latest copy of your page.

Sign in to reply to this post

John LangerBeta Tester

Hi Jason,

Latest page attached. The remaining pages have not been touched

Attached Files
wasp_newsletter.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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


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

Sign in to reply to this post

John LangerBeta Tester

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

Attached Files
wasp_newsletter.zip
Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...