function fetchTheatreOptions() { $dao = new DAO(); return $dao->fetchTheatreIDs(); }
function q8() { $dao = new DAO(); echo "\n\t\t\t\t<form action=\"\" method=\"post\">\n\t\t\t\tchoose a Theare <select name=\"threadselect\" onchange=\"Q8(this.value)\" required> "; echo '<option value =\'\' selected=\'selected\' >----must select one---</option>'; foreach ($dao->fetchTheatreIDs() as $rows) { foreach ($rows as $value) { echo "<option value ={$value} >" . $dao->fetchTheatreName($value) . '</option>'; } } echo "</select>\n\t\t\t\t\n\t\t\t\t</form>"; }