echo "<form action=\"mc.php\" method=\"post\">";
echo "Stat Filter: ";
$sql = "SELECT DISTINCT Stat1 FROM recipe UNION SELECT DISTINCT Stat2 FROM recipe UNION SELECT DISTINCT Stat3 FROM recipe UNION SELECT DISTINCT fill FROM recipe ORDER BY Stat1";
//$sql = "SELECT DISTINCT Stat1, Stat2, Stat3 from recipe ORDER BY Stat1";
$stat_result = mysqli_query($mcdb, $sql);
echo "<select name='Name'>";
while ($row = mysqli_fetch_array($stat_result)) {
        echo "<option value='" . $row['Stat1'] . "'>" . $row['Stat1'] . "</option>";
}
echo "</select>";
echo "<br>";
echo "<input type=submit value=\"Filter\">";
echo "</form>";
echo "Click the 'Filter' button with a blank entry to reset";

$stat_select = $_POST['Name'];


mysql> describe recipe;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| ID          | int(11)      | NO   | PRI | NULL    | auto_increment |
| Name        | varchar(100) | NO   |     | NULL    |                |
| Typenum     | int(11)      | NO   |     | NULL    |                |
| Type        | varchar(50)  | NO   |     | NULL    |                |
| Ingredients | varchar(200) | NO   |     | NULL    |                |
| Stat1       | varchar(50)  | NO   |     | NULL    |                |
| Stat2       | varchar(50)  | NO   |     | NULL    |                |
| Stat3       | varchar(50)  | YES  |     | NULL    |                |
| Notes       | varchar(255) | YES  |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+