<?include "conninfo.php";?>
<html>
<head>

</head>
<body>
<form action="joinedtables.php" method="post">
<?$query="SELECT * FROM jobs ORDER BY jobtitle";
$result=mysqli_query($link,$query);?>

<select name="job">

<?while($r=mysqli_fetch_array($result))
{?>

<option value="<?echo $r["jobid"];?>"><?echo $r["jobtitle"];?></option>

<?}?>

</select>
<input type="submit">
</form>

</body>
</html>