Untitled

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

<style type="text/css">
body {background-image: url("http://www.glorioustreats.com/wp-content/uploads/2011/06/Margarita-Cookies.jpg")}
h1 {
    font-family: arial, sans-serif;
    text-align: center;
    }
h2 {
    font-family: arial, sans-serif;
    text-align: left;
    padding: 10 0 0 20;
    font-size: 20px;
    }
h3 {
    font-family: arial, sans-serif;
    text-align: left;
    padding: 10 0 0 20;
    font-size: 18px;
    }
h4 {
    font-family: arial, sans-serif;
    text-align: left;
    padding: 10 0 0 20;
    font-size: 18px;
    color: #228B22;
    }
p {
    font-family: arial, sans-serif;
    padding: 10 0 0 20;
    }

.form-style-5{
    max-width: 500px;
    padding: 10px 20px;
    background: #f4f7f8;
    margin: 10px auto;
    padding: 20px;
    background: #f4f7f8;
    border-radius: 8px;
    font-family: Georgia, "Times New Roman", Times, serif;
}
.form-style-5 fieldset{
    border: none;
}
.form-style-5 legend {
    font-size: 1.4em;
    margin-bottom: 10px;
}
.form-style-5 label {
    display: block;
    margin-bottom: 8px;
}

.form-style-5 select {
    font-family: Georgia, "Times New Roman", Times, serif;
    background: rgba(255,255,255,.1);
    border: none;
    border-radius: 4px;
    font-size: 16px;
    margin: 0;
    outline: 0;
    padding: 7px;
    width: 100%;
    box-sizing: border-box;
    -webkit-box-sizing: border-box;
    -moz-box-sizing: border-box;
    background-color: #e8eeef;
    color:#8a97a0;
    -webkit-box-shadow: 0 1px 0 rgba(0,0,0,0.03) inset;
    box-shadow: 0 1px 0 rgba(0,0,0,0.03) inset;
    margin-bottom: 30px;

}

.form-style-5 select:focus{
    background: #d2d9dd;
}
.form-style-5 select{
    -webkit-appearance: menulist-button;
    height:35px;
}
.form-style-5 .number {
    background: #1abc9c;
    color: #fff;
    height: 30px;
    width: 30px;
    display: inline-block;
    font-size: 0.8em;
    margin-right: 4px;
    line-height: 30px;
    text-align: center;
    text-shadow: 0 1px 0 rgba(255,255,255,0.2);
    border-radius: 15px 15px 15px 0px;
}

.form-style-5 input[type="submit"],
.form-style-5 input[type="button"]
{
    position: relative;
    display: block;
    padding: 19px 39px 18px 39px;
    color: #FFF;
    margin: 0 auto;
    background: #1abc9c;
    font-size: 18px;
    text-align: center;
    font-style: normal;
    width: 100%;
    border: 1px solid #16a085;
    border-width: 1px 1px 3px;
    margin-bottom: 10px;
}
.form-style-5 input[type="submit"]:hover,
.form-style-5 input[type="button"]:hover
{
    background: #109177;
}
img.ri
{
  display: block;
  margin-left: auto;
  margin-right: auto;
  margin-bottom: 2cm;
  max-height: 90%;
  max-width: 90%;
  top: 0;
  bottom: 100;
  left: 0;
  right: 0;

}

</style>

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


print "<form method=GET action='practiceresults.php' class='form-style-5'>";
print "<h1>Pick Your Poison</h1>";
print "</select><br><input type='submit' value='Browse All'></h3>";
print "<h2>Search</h2>";
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='Find My Margarita!'></form></h3>";

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