<?include "conninfo.php";
include "banner.php";
//print_r($_POST);

$id=$_POST["theid"];
$query="SELECT * FROM people WHERE id=$id";//use id to get approp data
$result=mysqli_query($link,$query);
$r=mysqli_fetch_array($result);//one row, so no while needed
?>
<h1>Edit record</h1>
<form action="commitedit.php" method="post">
First name:<input type="text" name="fn" value="<?echo $r["firstname"];?>"><br>
Surname:<input type="text" name="sn" value="<?echo $r["surname"];?>"><br>
Favourite Food:<input type="text" name="ff" value="<?echo $r["favfood"];?>"><br>
Link:<input type="text" name="li" value="<?echo $r["userlink"];?>"><br><br>
<input type="hidden" name="id" value="<?echo $id;?>">
<input type="submit" value="Edit">
</form>