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>

[Earnan]

Try changing the following lines:

1) // SET NAME/FFNUMBER VARIA
2) $value = $row['FFNumber']."-".$row['SurName']."-".$row['FirstName'];
3) echo "<option value= ".$value.">".$row['SurName']." ".$row['FirstName']."</option>";

Also, what is your key in the table? Is it FFNumber? If so, maybe you should think of just using that as the $value. You can look up the other information with a query later if you need to display or use it.