$subject = $course = null; $conn = mysql_connect('', '', ''); $db = mysql_select_db('',$conn); if(isset($_GET["subject"]) && is_numeric($_GET["subject"])) { $subject = $_GET["subject"]; } if(isset($_GET["course"]) && is_numeric($_GET["course"])) { $country = $_GET["course"]; } ?> <script language="JavaScript"> function autoSubmit() { var formObject = document.forms['theForm']; formObject.submit(); } </script> <form name="theForm" method="get"> <select name="subject" önChange="autoSubmit();"> <option value="null">Select a Subject...</option> $sql = "SELECT DISTINCT subj_name, subj_id FROM table1 ". " ORDER BY subj_name"; $result = mysql_query($sql) or die ("couldn't execute query"); while($row = mysql_fetch_array($result)) { echo ("<option value=\"$row[subj_id]\" " . ($subject == $row["subj_id"] ? " selected" : "") . ">$row[subj_name]</option>"); } ?> </select> if($subject != null && is_numeric($subject)) { ?> <select name="course" önChange="autoSubmit();"> <option value="null">Select a Course...</option> $sql = "SELECT DISTINCT course_id, course_name, subj_id FROM table1 ". "WHERE subj_id = $subject"; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { echo ("<option value=\"$row[course_id]\" " . ($course == $row["course_id"] ? " selected" : "") . ">$row[course_name]</option>"); } ?> </select> } ?> </form>
if(isset($_GET["course"]) && is_numeric($_GET["course"])) { $country = $_GET["course"]; }
$country =
$course =
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)