<html>
<head>


</head>
<body>
<form action="jobsearch.php" method="post">

<?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>
<input type="submit">
</form>

</body>
</html>