title: How Would I Return Two Multiple Select Values In HTML?
body: <p>I have a mysql database table called "leads" with an id column, a name column, and an email column.  I currently have users selecting a lead from a multiple select box, which is returned as an array from an html <code>form</code> with <code>$_POST</code> method.  I have the value for the select box items as the email column, and what is shown to the user on the front end is the name column.  However, I want to be able to return two values, the email and the name, for later use.  I need to have the email value(s) able to be imploded with commas between them, so I can later send them emails using PHP's <code>mail</code> function.  However, when a user looks at sent emails, I want to show them the name value(s).  I have read that I can either parse the array, or use the id column set as the value, which seems more practical, however, I am not sure how I would go about this.  Any ideas?  Thanks in advance for any help!</p>
  
  <p>*<strong><em>UPDATE</em>*</strong></p>
  
  <p><strong>Basically, the users that log into the site have their own leads in a mysql database.  I need them to be able to go to a 'send email' page, where they can select a lead, or multiple leads, by name.  Then there is a subject field, and a message field so they can write the email, and then I have a 'send email' form submit button.  After they click 'send email' I want to get back the email addresses and names of the leads they selected, for later use.  I need to have the email addresses separated by commas, so that I can send them through a php mail function...  But the important thing is, I want the info from the form to be stored in a database table called 'PendingEmails', and I am going to run a cron job to run a script that finds what emails need to be sent, and sends them...  After an email is sent, I need to put the names, subject, and message from the email in a separate database, called 'SentEmails'.  On a different page on the site, I want the users to be able to see all the emails they sent, but I want them to see the names of who they sent it to, rather than the email addresses.  This is why I need both the names and the emails.  I need emails for the mail function, and names to be displayed back to the user.  I like your idea of using the id and running the rest server side, I just dont know how I would do this.  Hope this helped.</strong></p>
  
  <p><strong>Here is the select box:</strong></p>
  
  <pre><code>&lt;select data-placeholder="Select Lead(s) To Email..." multiple="true" class="chzn-container-multi" name="selectleads[]"style="width:505px;"&gt;
              &lt;?php
  do {  
  ?&gt;
              &lt;option value="&lt;?php echo $row_rsAllLeads['Email']?&gt;"&gt;&lt;?php echo $row_rsAllLeads['FullName']?&gt;&lt;/option&gt;
              &lt;?php
  } while ($row_rsAllLeads = mysql_fetch_assoc($rsAllLeads));
    $rows = mysql_num_rows($rsAllLeads);
    if($rows &gt; 0) {
        mysql_data_seek($rsAllLeads, 0);
        $row_rsAllLeads = mysql_fetch_assoc($rsAllLeads);
    }
  ?&gt;
            &lt;/select&gt;
  </code></pre>
  
  <p><strong>And here is the actual form action:</strong></p>
  
  <pre><code>$editFormAction = $_SERVER['PHP_SELF'];
  if (isset($_SERVER['QUERY_STRING'])) {
    $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
  }
  
  if ((isset($_POST["MM_insert"])) &amp;&amp; ($_POST["MM_insert"] == "form")) {
      $startcode = $_POST['messagefield'];
      $replaced = preg_replace( '/\\\\(?="|\')/', '', $startcode );
      $selected = $_POST['selectleads'];
      $collectedleads = implode(", ", $_POST['selectleads']);
   $to = $collectedleads;
   $subject = $_POST['subjectfield'];
   $body = $replaced;
   $headers = "MIME-Version: 1.0\r\n"; 
   $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
   $headers .= "From: " . $row_rs_CurrentUser['FirstName'] . " " . $row_rs_CurrentUser['LastName'] . " &lt;" . $row_rs_CurrentUser['Email'] . "&gt;";
   if (mail($to, $subject, $body, $headers)) {
    } else {
     echo("&lt;p&gt;Message delivery failed...&lt;/p&gt;");
    }
  
  }
  </code></pre>
  
  <p><strong>The code you gave me and I tried (and failed) to edit and make work:</strong></p>
  
  <pre><code>$editFormAction = $_SERVER['PHP_SELF'];
  if (isset($_SERVER['QUERY_STRING'])) {
    $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
  }
  
  if ((isset($_POST["MM_insert"])) &amp;&amp; ($_POST["MM_insert"] == "form")) {
      $startcode = $_POST['messagefield'];
      $replaced = preg_replace( '/\\\\(?="|\')/', '', $startcode );
  
      mysql_select_db($database_myBackOfficeConn, $myBackOfficeConn);
  
      $collectedleads = implode(", ", $_POST['selectleads']);
  
  //arrays to store email addresses and names
  $emails = array();
  $names = array();
  
  foreach ($collectedleads as $id) {
    mysql_query("SELECT Email, FullName FROM Leads 
      WHERE Id = " . mysql_real_escape_string($id));
  
    while ($row = mysql_fetch_assoc()) {
      $emails[] = $row['Email'];
      $names[] = $row['FullName'];
    }
  }
   $to = $collectedleads;
   $subject = $_POST['subjectfield'];
   $body = $replaced;
   $headers = "MIME-Version: 1.0\r\n"; 
   $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
   $headers .= "From: " . $row_rs_CurrentUser['FirstName'] . " " . $row_rs_CurrentUser['LastName'] . " &lt;" . $row_rs_CurrentUser['Email'] . "&gt;";
   if (mail($to, $subject, $body, $headers)) {
    } else {
     echo("&lt;p&gt;Message delivery failed...&lt;/p&gt;");
    }
  
  }
  
  ?&gt;
  </code></pre>