Hello
I am trying to build a multi-leveled drop-down box based sorting system via php. You may see an example from "http://www.dbasi.com/index.php?page=portfolio"
For some reason, my code doesn`t produce any results.
Can anybody help me please?
<p> <div class="pulldown">
<form method="GET" action="<?=$self?>" name="select" >
Courses by:
<select name="formcoursetype">
<option>
<option name="all" selected>All</option>
<option name="undergraduate" >Undergraduate</option>
<option name="graduate" >Graduate</option>
</option>
</select>
<select name="formcoursearea">
<option>
<option name="all" selected>All</option>
<option name="film" >Film</option>
<option name="humanities" >Humanities</option>
</option>
</select>
<input type="submit" value="show ยป" />
</form>
</div></p><br />
<?php
if ( isset($_POST['submit']) ) {
$coursetype = $_POST['formcoursetype'];
$coursearea = $_POST['formcoursearea'];
$filter = array('a.coursetype' => $coursetype, 'a.coursearea' => $coursearea);
foreach ( $filter as $k => $v ) {
if ( !empty($v) ) {
$val = ( is_int($v) ) ? $v : "'$v'";
$build_query[] = "`$k` = $val";
}
}
if ( count($build_query) >= 1 )
$que = $db->query("SELECT * FROM
cm AS a, cc AS b
WHERE a.id = b.cmid
AND b.courseyear >= 2007
ORDER BY a.coursecode, a.coursenumber, b.coursesection;");
while($row = mysql_fetch_object($que)){
printf( '<div class="info">
<br><h2>%s%s - %s</h2><br>
Semester: %s %s<br>
%s Credit Hours<br /><br />
%s <br />
</div>',
$row->coursecode, $row->coursenumber, $row->coursetitle, $row->coursesemester, $row->courseyear, $row->credithours, $row->coursedescription);}
}
?>
