Help-Putting Results Data Into Another Selection Box

[mcubedma]

I have a form that returns multiple rows and I'd like to put those rows into another selection box so that the user can select one record to display details. Can anyone help me with the code to do that? I am stuck. Thanks!

Here is what I have so far:

...

while ($member_info = mysql_fetch_array($get_member_res))
{$mbr_id = ($member_info['mbr_id']);
$f_name = ($member_info['f_name']);
$l_name = ($member_info['l_name']);

$get_address_sql = "SELECT address, city, state, zip from address where mbr_id = '$mbr_id'";
$get_address_res = mysql_query($get_address_sql, $link)
			   or die(mysql_error()); 

while ($address_info = mysql_fetch_array($get_address_res))
{$address = ($address_info['address']);
$city = ($address_info['city']);
$state = ($address_info['state']);
$zip = ($address_info['zip']);

$display_member .= "<p>$mbr_id<br>$l_name, $f_name<br>$address<br>$city, $state  $zip</p>";

...
}

echo $display_member;

[reddrum]

Maybe somthing like this?

print"<select>";
while ($member_info = mysql_fetch_array($get_member_res))
{$mbr_id = ($member_info['mbr_id']);
$f_name = ($member_info['f_name']);
$l_name = ($member_info['l_name']);

print"<option>$f_name." ".$l_name</option>";

$get_address_sql = "SELECT address, city, state, zip from address where mbr_id = '$mbr_id'";
$get_address_res = mysql_query($get_address_sql, $link)
               or die(mysql_error());

while ($address_info = mysql_fetch_array($get_address_res))
{$address = ($address_info['address']);
$city = ($address_info['city']);
$state = ($address_info['state']);
$zip = ($address_info['zip']);

$display_member .= "<p>$mbr_id<br>$l_name, $f_name<br>$address<br>$city, $state  $zip</p>";

...
}
print"</select>";