copy a query

[lukeurtnowski]

On my site I have 2 combo boxes (1 to select a member to delete and another to select a member to edit). The Delete one uses a mysql culomn to populate it,\

<select name="id" id="name">
)<option value="0" selected>(please select:)</option>
<?php   while($row = mysql_fetch_assoc($result))
{
    echo "<option value=".$row['id'].">".$row['Last_Name'].", ".$row['First_Name']."</option>";
} 
?>
</select>                                                     

How do /I copy it so that the Edit one is populated like that one?
http://mvsr.org/secure/members.php

Do I have to query the database again or is there a better way"?
Thanks...

[aidos]

If you want to use the same query result set for both combo boxes, you can use mysql_data_seek before creating the second combo box.

[donboe]

Why not make just 1 select/combo box with member names and two radio buttons(1 for edit and 1 for delete), and depending which radio button chosen take the appropriate action!

[lukeurtnowski]

thanksss