';
$where_line = $where_line . " level = '" . $level . "' ";
if ((isset($_POST['day_of_week']) && $_POST['day_of_week'] != '%') || (isset($_POST['time']) && $_POST['time'] != '%') || (isset($_POST['category']) && $_POST['category'] != '%') || (isset($_POST['instructor']) && $_POST['instructor'] != '%')) {
$where_line = $where_line . " and ";
}
}
if (isset($_POST['day_of_week']) && $_POST['day_of_week'] != '%') {
$where_line = $where_line . " day_of_week like '%" . $day_of_week . "%' ";
if ((isset($_POST['time']) && $_POST['time'] != '%') || (isset($_POST['category']) && $_POST['category'] != '%') || (isset($_POST['instructor']) && $_POST['instructor'] != '%')) {
$where_line = $where_line . " and ";
}
}
if (isset($_POST['time']) && $_POST['time'] != '%') {
$where_line = $where_line . " time like '%" . $time . "%' ";
if ((isset($_POST['category']) && $_POST['category'] != '%') || (isset($_POST['instructor']) && $_POST['instructor'] != '%')) {
$where_line = $where_line . " and ";
}
}
if (isset($_POST['category']) && $_POST['category'] != '%') {
$where_line = $where_line . " category like '%" . $category . "%' ";
if ((isset($_POST['instructor']) && $_POST['instructor'] != '%')) {
$where_line = $where_line . " and ";
}
}
if (isset($_POST['instructor']) && $_POST['instructor'] != '%') {
$where_line = $where_line . " instructor = '" . $instructor . "' ";
}
$sql_where = $where_line;
}
$results = mysql_query('select * from kansai_courses ' . $sql_where . '
;');
?>
検索結果
クラスコード |
種類 |
講座名・テキスト |
課 |
講師 |
曜日 |
時間 |
時間数 |
授業料 |
クラス概要 |
備考 |
|
|
|
|
|
|
|
|
|
|
|