one form for selectable email data loops

Hi I'm creating a email form for a stage production where I want to be able to send emails via a drop down menu list (for the recipient groups) I created already recordsets for cast, band, crew etc. how can I make universal email make recognize the email addresses of the selected menu option and the recordset assigned with it.

Thanks

i dont follow, can you provide more derails please.

In the email form the recipient (email to) is a list of different groups, e.g. if I want to send an email to all cast members I select "cast" and the recordset lists the email addresses of the group "cast" if I want to send emails to the band I select "Band" an the recordset lists the email addresses of the group "band" ... so UE needs to recognize which recordset to use. (see screen shot attached)

dont use multiple recordsets. use only one recordset.

the value of the select list should pass the group ID, you can then use the select list to filter the recordset on the selected group ID to return the emails for the selected group.

Hi Jason, Thanks this makes sense for a single group, if I want two groups selected and would use the "contains" statement how would the value in the form look? What is the separator for multiple values?

to select multiple groups, you would need to set the Select list as a multiple select list, and edit the name to include "[]" at the end:

<select name="selectName[]" multiple id="select">

The way a multiple select list works in PHP is that the selections are added to an array. The array needs to be converted to a comma separated list. Add the following code at line 1 to convert the array:

<?php

if($_SERVER["REQUEST_METHOD"] == "POST")     {

    foreach($_POST as $key => $val) {

        if(is_array($_POST[$key])) $_POST[$key] = implode(", ", $_POST[$key]);

    }

}

?>

when creating the recordset, you will need to use advanced mode. in the recordset, you can use the IN keyword in the WHERE Clause, for example a simple recordset to select where multiple IDS exist, would look like:

SELECT * FROM tableName WHERE groupID IN (1, 4, 5)

to use the select list value instead of hard coding the group IDs:

SELECT * FROM tableName WHERE groupID IN (".((isset($_POST['selectName']) && $_POST['selectName'] !="")?$_POST['selectName']:"199").")