Inserting members attending meeting into table using select multiple.

[hostinsa]

I need to browse my members table and then add all members that attended a meeting into the Meeting_attended table.

I am using a form and <Select Multiple> to get the member numbers .

Here is my code:
if($Save_this){
$meet_date=date(Y);
$meet_date.=".";
$meet_date.=$mth;
$meet_date.=".";
$meet_date.=$day;

		$xx=0;

		foreach($_POST['members'] as $xx=>$member) { 
		 echo 'Saving  ' . $member . '<br />'; 

		$query = "INSERT INTO meetings_attended (member,date,time,meeting_type,venue)  VALUES ('$member','$meet_date','$meet_time','$meeting_type','$venue')"; 
		$result = mysql_query($query) or die(mysql_error()); 

		$xx++; 
		}   

} // End if

?>
</p>
<form action="meetings_captured.php" method="post" enctype="multipart/form-data">
<table width="751" border="2" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<!--DWLayoutTable-->

<tr> 
  <td colspan="1" align="center" valign="top"> <p><font size="4"><strong><font size="7" face="Verdana, Arial, Helvetica, sans-serif">Member 
      Presensielys</font></strong></p>
    <p><font size="5">Attending the 
      <select name="meeting_type" >
        <option value="Provincial Management">Provincial Management</option>
		<option value="Provincial Meeting">Provincial Meeting</option>
        <option value="Provincial AGM">Provincial AGM</option>
        <option value="Club Management">Club Management</option>
		<option value="Club Meeting">Club Meeting</option>
        <option value="Club AGM">Club AGM</option>
      </select>
      meeting at 
      <input type="text" name="venue" maxlength="100" size="20">
      <br>
      on 
      <select name="day">
        <option value="01">01</option>
        <option value="02">02</option>
        <option value="03">03</option>
        <option value="04">04</option>
        <option value="05">05</option>
        <option value="06">06</option>
        <option value="07">07</option>
        <option value="08">08</option>
        <option value="09">09</option>
        <option value="10">10</option>
        <option value="11">11</option>
        <option value="12">12</option>
        <option value="13">13</option>
        <option value="14">14</option>
        <option value="15">15</option>
        <option value="16">16</option>
        <option value="17">17</option>
        <option value="18">18</option>
        <option value="19">19</option>
        <option value="20">20</option>
        <option value="21">21</option>
        <option value="22">22</option>
        <option value="23">23</option>
        <option value="24">24</option>
        <option value="25">25</option>
        <option value="26">26</option>
        <option value="27">27</option>
        <option value="28">28</option>
        <option value="29">29</option>
        <option value="30">30</option>
        <option value="31">31</option>
      </select>
      / 
      <select name="mth">
        <option value="01">01</option>
        <option value="02">02</option>
        <option value="03">03</option>
        <option value="04">04</option>
        <option value="05">05</option>
        <option value="06">06</option>
        <option value="07">07</option>
        <option value="08">08</option>
        <option value="09">09</option>
        <option value="10">10</option>
        <option value="11">11</option>
        <option value="12">12</option>
      </select>
      /<? echo date(Y) ?></font><font size="4"><font size="6">. 
      <input name="meet_time" type="text" id="time" value="00:00" size="5" maxlength="5">
      </font></font>&nbsp;<br>
    </p></td>

</tr>

<tr> 

  <td ALIGN="center"><div align="center"><font size="2"><b>Member</b></font>&nbsp;: 
      <b>Name &amp; Surname</b></div></td>
</tr>
<tr> 

  <td valign="top">
  <select name="members[]" size="20" multiple>
<?php

		$result = mysql_query("SELECT * FROM `members` where prov='$prov' AND member_status='PAID IN FULL' ORDER BY lastname",$db);

					while ($myrow = mysql_fetch_array($result)) {
		?>

      <option value="<? echo $myrow["member"] ?>" ><? echo $myrow["member"] ?>&nbsp;<? echo $myrow["noemnaam"] ?> 
      &nbsp; <? echo $myrow["lastname"] ?> </option>


<?php				
   }
?>
			</select>

</td>

</tr>
  <td><div align="center"><strong><font color="#FF0000">Hold Control in while 
      Selecting Members</font></strong></div><br>
	   <input type="submit" name="Save_this" value="Save This">
	  </td>

</tr>

</table>

</form>
<p></table> </p>
<p><br>
</p>
</body>
</html>