fetching data in dropdown menu from the database

[akhan]

i used the following code to enter data in dropdown menu :

<?
$con=mysql_connect("","","");
mysql_select_db('investment',$con);
 
$query="select *from personal_info";
$res = mysql_query($query);
echo '<label>Select</label>';
echo '<select id="id" name="val">';
echo '<option value="">#</option>';
while ($row = mysql_fetch_assoc($res)) 
{
     $va = $row['employee_id'];
echo $va;
echo "<option value='$va'>$va</option>";
}
echo '</select>';
?>

now, i want that whenever i click on the serial number inside the drop-down menu, i directly reach on the edit portion of data corresponding to that serial number (employee_id) which i can edit further.

PLEASE HELP ME...!!!!!

[Motoma]

i used the following code to enter data in dropdown menu :

<?
$con=mysql_connect("","","");
mysql_select_db('investment',$con);
 
$query="select *from personal_info";
$res = mysql_query($query);
echo '<label>Select</label>';
echo '<select id="id" name="val">';
echo '<option value="">#</option>';
while ($row = mysql_fetch_assoc($res)) 
{
     $va = $row['employee_id'];
echo $va;
echo "<option value='$va'>$va</option>";
}
echo '</select>';
?>

now, i want that whenever i click on the serial number inside the drop-down menu, i directly reach on the edit portion of data corresponding to that serial number (employee_id) which i can edit further.

PLEASE HELP ME...!!!!!

You will either need to post to another page (perhaps edit.php) or use AJAX to bring up an edit screen for the object. Then post the changes and perform the update.