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


</head>
<body>
<h1>Add new record:</h1>
<form method="post" action="insertnewdata.php">
First name:<input type="text" name="fn"><br>
Surname: <input type="text" name="sn"><br>
Favourite Food: <input type="text" name="ff"><br>

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

Starsign: <select name="ss">

<?while($r=mysqli_fetch_array($result))
{?>
<option value="<?echo $r["sid"];?>">
<?echo $r["starsignname"];?>
</option>
<?}?>


</select>

<br>


Link: <input type="text" name="li"><br><br>
<input type="submit" value="Submit">
</form>

</body>
</html>