require_once "../includes/config.php"; //************************************** // Page load dropdown results // //************************************** function getTierOne() { $result = mysql_query("SELECT DISTINCT tier_one FROM two_drops") or die(mysql_error()); while ($tier = mysql_fetch_array($result)) { echo '<option value="' . $tier['tier_one'] . '">' . $tier['tier_one'] . '</option>'; } } //************************************** // First selection results // //************************************** if ($_GET['func'] == "drop_1" && isset($_GET['func'])) { drop_1($_GET['drop_var'], $_GET['drop_var2']); } function drop_1($drop_var, $drop_var2) { require_once "../includes/config.php"; $result = mysql_query("SELECT * FROM faqcategory WHERE faqCategoryParentId='{$drop_var}'") or die(mysql_error()); echo '<select name="tier_two" id="tier_two">'; if (isset($_GET['action']) && $_GET['action'] == 'add') { ?> <option value=" " disabled="disabled" selected="selected">Choose one</option>'; <?php } while ($drop_2 = mysql_fetch_array($result)) { ?> <option <?php if ($drop_2['faqCategoryId'] == $drop_var2) {
<?php function getFaculties() { $query = "select faculty_name from faculty"; $result = mysql_query($query); while ($faculty = mysql_fetch_array($result)) { $value = $faculty[0]; echo '<option value="' . $value . '"> Faculty of ' . $value . '</option>'; } } if (isset($_GET['func']) && $_GET['func'] == "drop_1") { drop_1($_GET['drop_var'], $_GET['course_var']); } if (isset($_GET['load_courses']) && $_GET['load_courses'] == "load_courses") { load_courses($_GET['drop_var'], $_GET['course_var']); } function load_courses($drop_var, $course_var) { include_once 'connection.php'; $query = "select faculty_id from faculty where faculty_name='{$drop_var}'"; $result = mysql_query($query); if ($result) { $value = mysql_fetch_assoc($result); $faculty_id = $value['faculty_id']; $query = "SELECT `course`.* FROM `course` JOIN `course_faculty` ON `course`.`course_id` = `course_faculty`.`course_id`\n WHERE `course_faculty`.`faculty_id` = {$faculty_id} and `course`.`course` like '%{$course_var}%'"; $result = mysql_query($query); $row_count = mysql_num_rows($result); $num = $row_count % 3 == 0 ? $row_count / 3 : (int) ($row_count / 3) + 1; $count = 0;
if (!is_numeric($drop_var)) { exit; } include_once 'dbconnect.php'; $result = mysql_query("SELECT * FROM elite_level_model WHERE make_id={$drop_var} ORDER BY title asc") or die(mysql_error()); echo '<select name="model" id="drop_3"> <option value=" " disabled="disabled" selected="selected">Select Model</option>'; while ($drop_3 = mysql_fetch_array($result)) { echo '<option value="' . $drop_3['id'] . '">' . $drop_3['title'] . '</option>'; } echo '</select>'; echo "<script type=\"text/javascript\"> \r\n \r\n \r\n jQuery('#drop_3').change(function() {\r\n \r\n jQuery('#cpkBtn').show('fast');\r\n });\r\n \r\n </script>"; //echo "<script type=\"text/javascript\">$('#wait_2').hide();</script>"; //echo '<input type="button" class="vafSubmit" value="Search">'; //echo '<img id="goBtn" src="goBtn.png"/>'; } //************************************** // First selection results // //************************************** if (isset($_GET['func'])) { if ($_GET['func'] == "drop_1") { drop_1($_GET['drop_var']); } //************************************** // Second selection results // //************************************** //$result = mysql_query("SELECT * FROM elite_level_model WHERE make_id=$drop_var ORDER BY title desc") if ($_GET['func'] == "drop_2") { drop_2($_GET['drop_var']); } }