Untitled

<html>
<head>
<title>Pick Your Poison</title>
</head>
<body>

<style>
body {background-image: url("margarita cookies.jpg")}
h1 {text-align: center}
h3 {margin-left: 30px}
</style>

<?php
$host="localhost";
$username="alcohaul";
$password="drunk";
$database="alcohaul";
$link= mysqli_connect($host,$username,$password,$database);

print "<h1>Pick Your Poison</h1>";

print "<form method=GET action='practiceresults.php'>";
print "<h3>Consistency: <select name='type'>";
$typeresult= mysqli_query($link, 'SELECT * FROM type');
print "<option value='No preference'></option>";
while ($row = mysqli_fetch_array($typeresult)){
   print "<option value='$row[type_id]'> $row[type]</option>";
}
print "</select><br />";

print "Happy Hour Availability: <select name='happy_hour'>";
$hhresult= mysqli_query($link, 'SELECT * FROM happy_hour');
print "<option value='No preference'></option>";
while ($row = mysqli_fetch_array($hhresult)){
   print "<option value='$row[hh_id]'> $row[hh]</option>";
}
print "</select><br />";

print "Flavor: <select name='flavor'>";
$flavorresult= mysqli_query($link, 'SELECT * FROM flavor ORDER BY flavor');
print "<option value='No preference'></option>";
while ($row = mysqli_fetch_array($flavorresult)){
   print "<option value='$row[flavor_id]'> $row[flavor]</option>";
}
print "</select><br />";

print "Restaurant Area: <select name='area'>";
$arearesult= mysqli_query($link, 'SELECT * FROM area ORDER BY area');
print "<option value='No preference'></option>";
while ($row = mysqli_fetch_array($arearesult)){
   print "<option value='$row[area_id]'> $row[area]</option>";
}
print "</select><br />";

print "Restaurant Name: <select name='rest'>";
$restresult= mysqli_query($link, 'SELECT * FROM rest ORDER BY rest');
print "<option value='No preference'></option>";
while ($row = mysqli_fetch_array($restresult)){
   print "<option value='$row[rest_id]'> $row[rest]</option>";
}
print "</select><br><input type='submit' value='Pick or Browse All'></form></h3>";

mysqli_close($link);
?>
</body>
</html>