<form>
                <p> Our favourites:</p>
                    <input type="radio" name="favourite" value="Spicy Tuna Mayo Wrap" checked> Spicy Tuna Mayo Wrap
                    <input type="radio" name="favourite" value="Vegan Sausage Sandwich" > Vegan Sausage Sandwich
                    <input type="radio" name="favourite" value="Chicken/Bacon/Mayo" > Chicken/Bacon/Mayo
            </form>

            <!--form reads relevant ingredient lists from database-->
            <form>
                <?php

                //set db params
                $servername="127.0.0.1";
                $username="root";
                $password="password";
                $dbname="FF_TEST";

                //establish & check mysqli connection
                $conn = new mysqli($servername, $username, $password, $dbname);
                if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
                }

                //prepare statement to select ingredient of each category
                $stmt = $conn->prepare("SELECT INGREDIENT_NAME FROM INGREDIENT WHERE INGREDIENT_CAT=?");
                $stmt->bind_param("s", $ingredient_cat);

                //process each category in turn
                $ingredient_cat="Filling";
                get_display_ingredients($stmt, $ingredient_cat);

                $ingredient_cat="Extra";
                get_display_ingredients($stmt, $ingredient_cat);

                $ingredient_cat="Bread";
                get_display_ingredients($stmt, $ingredient_cat);

                $ingredient_cat="Sauce";
                get_display_ingredients($stmt, $ingredient_cat);

                $ingredient_cat="Leaves";
                get_display_ingredients($stmt, $ingredient_cat);

                /*
                 * get_display_ingredients takes prepared sql statement and the category name
                 *  executes the query with given category name
                 *  displays returned ingredients in a separate table for each cat
                 */
                function get_display_ingredients($stmt, $cat) {
                    $stmt->execute();
                    $result = $stmt->get_result();

                    //if the query was successful, create a new inline table
                    //  table header is the category name
                    if($result->num_rows > 0){
                        echo "<table style='display: inline-block'>
                            <th>$cat</th>";

                        //create a new table row containing a checkbox for each ingredient
                        while($row = $result->fetch_assoc()){
                            $ing_name = $row["INGREDIENT_NAME"];
                            echo "<tr><td><input type='checkbox' name='$cat' value=''>" .$ing_name. "</tr></td>" ;
                        }
                        echo "</table>";
                        } else {
                        echo "0 results";
                    }
                }

                $conn->close();
                ?>
            </form>