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!

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'] ."";

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.

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.

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.

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.

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!