<html>
<head>

</head>
<body>
<h1>Enter new record:</h1>
<form action="insertnew.php" method="post">
First name:<input type="text" name="fname"><br>
Surname:<input type="text" name="sname"><br>
Favourite Food:<input type="text" name="ffood"><br>
Postcode:<input type="text" name="pcode"><br>


<?include "conninfo.php";
$query="SELECT * FROM job";
$result=mysqli_query($link,$query);?>Job:
<select name="thejob">
<?
while($r=mysqli_fetch_array($result))
{
echo "<option value='".$r["jobid"]."'>".$r["jobname"]."</option>";
}
?>
</select>


<br><br>
<input type="submit" value="Add record">
</form>

</body>
</html>