One result set makes two lists with same keys and values

[Noyb]

I have a page with two drop-downs, each listing the same employee names
and their id's as the values. So they look like:
<select name="selection_1">
<option value="12">Curly</option>
<option value="8">Larry</option>
<option value="36">Moe</option>
</select>

....then further down the page:

<select name="selection_2">
<option value="12">Curly</option>
<option value="8">Larry</option>
<option value="36">Moe</option>
</select>

Currently I am doing this, which works but seems sloppy:

<select name="selection_1">
<?
while($employees=mysql_fetch_assoc($qry_rslt)) {
/* ADD NAMES TO DROPDOWN WITH emp_id's AS THEIR VALUES */
?><option
value="<?=$employees['emp_id']?>"><?=$employees['name']?></option><?

/* CREATE ANOTHER ARRAY WITH THE emp_id AS THE KEY */
$emp_list_2[$employees['emp_id']]=$employees['name'];
}
?>
</select>

Then on the second drop-down:

<select name="selection_2">
<?
foreach($emp_list_2 as $key => $emps) {
?>
<option value="<?=$key?>"><?=$emps?></option>
<?
}
?>
</select>
Is there a better way to do this?
Thanks.
Steve.

[Agelmar]

Noyb wrote:

I have a page with two drop-downs, each listing the same employee
names and their id's as the values. So they look like:
<select name="selection_1">
<option value="12">Curly</option>
<option value="8">Larry</option>
<option value="36">Moe</option>
</select>

...then further down the page:

<select name="selection_2">
<option value="12">Curly</option>
<option value="8">Larry</option>
<option value="36">Moe</option>
</select>

Currently I am doing this, which works but seems sloppy:

<select name="selection_1">
<?
while($employees=mysql_fetch_assoc($qry_rslt)) {
/* ADD NAMES TO DROPDOWN WITH emp_id's AS THEIR VALUES */

<option
value="<?=$employees['emp_id']?>"><?=$employees['name']?></option><?

/* CREATE ANOTHER ARRAY WITH THE emp_id AS THE KEY */
$emp_list_2[$employees['emp_id']]=$employees['name'];
}

</select>

Then on the second drop-down:

<select name="selection_2">
<?
foreach($emp_list_2 as $key => $emps) {

<option value="<?=$key?>"><?=$emps?></option>
<?
}

</select>
Is there a better way to do this?
Thanks.
Steve.

There is a slightly better way to do it...
$dropdown = "";
while($employees=mysql_fetch_assoc($qry_rslt)) {
$dropdown .= '<option
value="'.$employees['emp_id'].'">'.$employees['name']."<option>\n";
}

and then you can just do...
<select name ="select1">
<?php echo $dropdown; ?>
</select>

<select name="select2">
<?php echo $dropdown; ?>
</select>

-Ian

[Pedro Graca]

["Followup-To:" header set to comp.lang.php.]
Noyb wrote:

Currently I am doing this, which works but seems sloppy:

<select name="selection_1">
<?

$options = '';

while($employees=mysql_fetch_assoc($qry_rslt)) {
/* deleted /* ADD NAMES TO DROPDOWN WITH emp_id's AS THEIR VALUES */
?><option
value="<?=$employees['emp_id']?>"><?=$employees['name']?></option><?

/* CREATE ANOTHER ARRAY WITH THE emp_id AS THE KEY */
$emp_list_2[$employees['emp_id']]=$employees['name']; deleted */

$options .= "<option value='{$employess['emp_id']}'>{$employees['name']}</option>";
}
?>

<?=$options?>

</select>

Then on the second drop-down:

<select name="selection_2">
/* deleted<?
foreach($emp_list_2 as $key => $emps) {
?>
<option value="<?=$key?>"><?=$emps?></option>
<?
}
?> */ deleted

<?=$options?>
</select>

--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[Noyb]

Agelmar wrote:

Noyb wrote:

I have a page with two drop-downs, each listing the same employee
names and their id's as the values. So they look like:
<select name="selection_1">
<option value="12">Curly</option>
<option value="8">Larry</option>
<option value="36">Moe</option>
</select>

...then further down the page:

<select name="selection_2">
<option value="12">Curly</option>
<option value="8">Larry</option>
<option value="36">Moe</option>
</select>

Currently I am doing this, which works but seems sloppy:

<select name="selection_1">
<?
while($employees=mysql_fetch_assoc($qry_rslt)) {
/* ADD NAMES TO DROPDOWN WITH emp_id's AS THEIR VALUES */

<option
value="<?=$employees['emp_id']?>"><?=$employees['name']?></option><?

/* CREATE ANOTHER ARRAY WITH THE emp_id AS THE KEY */
$emp_list_2[$employees['emp_id']]=$employees['name'];
}

</select>

Then on the second drop-down:

<select name="selection_2">
<?
foreach($emp_list_2 as $key => $emps) {

<option value="<?=$key?>"><?=$emps?></option>
<?
}

</select>
Is there a better way to do this?
Thanks.
Steve.

There is a slightly better way to do it...
$dropdown = "";
while($employees=mysql_fetch_assoc($qry_rslt)) {
$dropdown .= '<option
value="'.$employees['emp_id'].'">'.$employees['name']."<option>\n";
}

and then you can just do...
<select name ="select1">
<?php echo $dropdown; ?>
</select>

<select name="select2">
<?php echo $dropdown; ?>
</select>

-Ian

Silly me, that's a much easier solution. Thanks!