require "../../../../php/anonymous.php"; session_start(); $where = "WHERE status = 1 "; if ($_REQUEST['id']) { $where .= "AND id = '{$_REQUEST['id']}'"; } else { $job_ids = ""; $keys = array_keys($_REQUEST); foreach ($keys as $key) { if (strpos($key, 'job_id_') !== FALSE) { $job_ids .= str_replace('job_id_', '', $key) . ', '; } } $where .= "AND id IN ({$job_ids}0) "; } //検索実行 $query = "SELECT * FROM job $where ORDER BY last_modified_date desc, id desc "; $result = $db->exec($query); $num = $db->num_rows($result); ?>
求人が選択されていません。
戻る