<?$id=$_POST["idtoedit"];

include "conninfo.php";

$query="SELECT * FROM employees WHERE id=$id";
$result=mysqli_query($link,$query);

$r=mysqli_fetch_array($result);

$jobid=$r["job"];


?>
<h2>Edit Record</h2>
<form action="commitedit.php" method="post">
First name: <input type="text" name="editedfn" value="<?echo $r["firstname"];?>"><br>
Surname: <input type="text" name="editedsn" value="<?echo $r["surname"];?>"><br>
Date of birth: <input type="text" name="editeddob" value="<?echo $r["dob"];?>">

<?$query2="SELECT * FROM joblist";
$result2=mysqli_query($link,$query2);
?>
<br>
Job: <select name="job">
<?while($r2=mysqli_fetch_array($result2))
{
$jid=$r2["jobid"];?>

<option value="<?echo $jid;?>" <?if($jid==$jobid){?>SELECTED<?}?>><?echo $r2["jobname"];?></option>
<?}?>
</select>
<input type="hidden" name="idtoedit" value="<?echo $r["id"];?> ">

<br><br>
<input type="submit" value="Commit Edit">
</form>











