title: PHP MySQL inserting multiple values from drop box selections
body: <p>I have a table populated by a MySQL table, and I am trying to insert the selected rows from the table into another table.</p>
  
  <p><strong>The table look like below:</strong>
  <a href="https://i.stack.imgur.com/uT87e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uT87e.png" alt="image"></a>. </p>
  
  <p>There are first three fields in the table are coming from two other tables depending on the Field values. </p>
  
  <p>And the drop down selections are provided by user using: </p>
  
  <pre><code>$sql = "SELECT project_proposals.id, project_proposals.title, project_proposals.description, project_proposals.academicname, flux_student_records.studentname, flux_student_records.id, flux_student_records.programme, flux_student_records.academicdiscipline FROM project_proposals JOIN flux_student_records ON project_proposals.academicdiscipline = flux_student_records.academicdiscipline 
  WHERE project_proposals.academicdiscipline = '$academicdiscipline' AND flux_student_records.studentname = '$studentname'";
  
  $retval = mysql_query($sql) or die(mysql_error());
  </code></pre>
  
  <p>What will be the best way to insert these multiple selected rows into another table please? Thanks. </p>