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


</head>
<body>

<form action="addnewdata.php" method="post">

First name:<input type="text" name="fn"><br>
Surname: <input type="text" name="sn"><br>
Email: <input type="text" name="em"><br>
Postcode: <input type="text" name="pc"><br>
Image: <input type="text" name="im"><br>
Favourite Link: <input type="text" name="fl"><br>

<?$query="SELECT * FROM joblist";
$result=mysql_query($query);?>

Job: <select name="jb">

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

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

<?}
?>

</select>






Starsign: <input type="text" name="ss">
<br><br>
<input type="submit" value="Submit">
</form>



</body>
</html>