<?include "conninfo.php";

$id=$_POST["idtoedit"];			//get id of button
$query="SELECT * FROM people WHERE id=$id";//get existing data
$result=mysql_query($query);	//run query
$r=mysql_fetch_array($result);	//get array

?>
<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>
Email: 		<input type="text" name="editedem" value="<?echo $r["email"];?>">	<br>
Postcode: 	<input type="text" name="editedpc" value="<?echo $r["postcode"];?>">	<br><br>

<input type="hidden" name="idtoedit" value="<?echo $id;?>">
<input type="submit" value="Commit Edit">

</form>



