close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Use variable in email title

Thread began 7/22/2011 7:33 am by scr298498 | Last modified 7/26/2011 5:46 am by scr298498 | 1302 views | 6 replies |

scr298498

Use variable in email title

Hey,

My client wants to be able to send two different 'kinds' of emails - 1. A full length newsletter 2. A brief note.
So I have a form setup with two radio buttons so he can choose which it will be. Effectively they are exactly the same, but he just wants the message subject to be different for each.
So depending which option he chooses the value is stored in the DB and then used to give the message subject.
The problem is that it's not working.
I first tried storing the values as either a 1 or a 2 and then using this code in WAUE_newsletterSend_1.php:

if ($row_getSubscribers['mailtype'] == '1') {
$MailSubject = "Ulysses Consulting 'In Brief' Note";
}
else {
$MailSubject = "Ulysses Consulting Monthly Newsletter";
}


But that didn't work so I tried storing the values as string and using:

$MailSubject     = "Ulysses Consulting ".$row_UCNewsletter['mailtype']  ."";


That is not working either. The subject line just shows as "Ulysses Consulting" (without the quotes)
Any help would be greatly appreciated!

Thanks!

Sign in to reply to this post

Ray BorduinWebAssist

It could be that your recordset is created on the page before it is updated, so references to the recordset don't have the mailtype set yet?

Maybe try referring to the radio button directly instead of the recordset in the code:
$MailSubject = "Ulysses Consulting ".$_POST['radio_field_name'] ."";

Sign in to reply to this post

scr298498

Hi Ray,

Thanks for that. The whole email gets stored in the DB and the info is then recalled later when the client wants to check or send the email so I'm not sure how calling the radio button value will work?
Sorry if I'm not understanding.

Sign in to reply to this post

Ray BorduinWebAssist

How are you filtering the UCNewsletter recordset? The code you have should work if the recordset returns the correct value. Most likely the issue is that the field isn't getting stored in the database correctly, or the recordset state isn't being maintained through the submit.

If you attach a copy of the page I might be able to spot the problem.

Sign in to reply to this post

scr298498

Everything is retrieved fine from the DB and I have checked the DB and the 'mailtype' field is stored as expected.
I have attached the WAUE_newslettersend file and the file the user send the mail from.
Thanks so much for your help! I really appreciate it.

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

Ray BorduinWebAssist

I don't see why it wouldn't work.

Add some debug code to the page above where you set the subject line:

<?php
var_dump($row_UCNewsletter);
die();
?>

See if that row has the values you would expect. This will stop the email from sending and will display all of the information from the recordset. My only guess is that the recordset doesn't have the information you think it does or else it would work.

View the source code of the page and it will be easier to read. Let me know what you find out.

Sign in to reply to this post

scr298498

Hi Ray,

I figured out the problem. The radio buttons had no default set so the client was able to submit an entry with no value selected - which he did. So it was actually working all along. I have now set a checked state for the first radio button.
My test send page then was not calling the 'mailtype' field from the DB so all my test emails weren't working.

Thanks again for your help!

Sign in to reply to this post

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...