Multiple Select Menus + JScript

[obrienkev]

Hi all,

I want to enable the user to add as many select menus as is required. Each select menu should be populated with data from a database table.

The menus are created ok but I am unable to get the data into the select menus.

Any ideas?

 $query = "SELECT FFNumber, FirstName, SurName, TDATE, EmpStatus ".
         "FROM EMPLOYEES_Registered";
 $result = mysql_query($query) or die(mysql_error());
 
 // DISPLAY LIST OF NAMES
 if(isset($error_message['ffnumber'])) { echo  $error_message['ffnumber']; }
 echo '<p id="qs"> '.
      '<label for="ffnumber">Name:</label> '.
          '<select name="ffnumber" id="ffnumber"> '.
      '<option value="0">Select Name</option>';
 
 while($row = mysql_fetch_array($result))
 {
 / SET NAME/FFNUMBER VARIABLE
 $value = $row['FFNumber'].'-'.$row['SurName'].'-'.$row['FirstName'];
 echo '<option value= "'.$value.'">'.$row['SurName'].' '.$row['FirstName'].'</option>';
 }
             
 echo '</select> '.
     '<button onclick="addStaff(); return false;">Add another</button></p>';
 ?> 

JavaScript:

 <script language="JavaScript" type="text/javascript">
 <!--
 
 var fieldCount = 1;
 function addStaff() 
 {
 		fieldCount++;
 		var newStaff = document.createElement('select');
 		newStaff.name = 'ffnumber[]' + fieldCount;
 		newStaff.id = 'ffnumber' + fieldCount;
 		document.getElementById('qs').appendChild(newStaff);
 }
 
 //-->
 </script>

[obrienkev]

Any ideas guys? Tried adding a option element to the javascript but didnt work. Still unable to get the data into the select menus.

[Pepejeria]

I don't really understand the question, how about some sample code that doesn't include php