<html>
<head>




</head>
<body>

<form action="insertrecord.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>

Job:

<?include "conninfo.php";
$query="SELECT * FROM jobs ORDER BY jobname";
$result=mysqli_query($link,$query);?>

<select name="thejob">
<?while($r=mysqli_fetch_array($result))
{?>
<option value="<?echo $r["jobid"];?>">
<?echo $r["jobname"];?>
</option>	
	
	
<?}?>
	

</select>

<br><br>

<input type="submit" value="Submit">


</form>





</body>
</html>