include_once "wines.php"; $obj2 = new wines(); $obj2->get_year(); while ($row = $obj2->fetch()) { echo "<option value='{$row['year']}''>{$row['year']}</option>"; } ?> </select> </div><br> <input type="submit" value="Search"> </form> </body> <?php if (isset($_REQUEST['wt'])) { include_once "adb.php"; include_once "wines.php"; $wine_type = $_REQUEST['wt']; $year = $_REQUEST['yr']; $obj = new wines(); echo "<table border='1'>"; echo "<tr style='background-color:purple; color:white;text-align:center'>\n\t\t\t<td>Wine ID</td><td>Wine Name</td><td>Wine Type</td><td>Year</td>\n\t\t\t<td>Winery Name</td></tr>"; $obj->multiple_search($wine_type, $year); while ($row = $obj->fetch()) { echo "<tr><td>{$row['wine_id']}</td><td>{$row['wine_name']}</td><td>{$row['wine_type']}</td><td>{$row['year']}</td><td>{$row['winery_name']}</td></tr>"; } echo "</table>"; } ?> </html>