if (PARAM1 != '') { $exam_id = PARAM2; unset($get); $get['table'] = 'exams'; $get['columns'] = array('exams.*','images.image'); $get['join'] = "INNER JOIN images ON images.table_name = 'exams' AND images.table_id = exams.id AND images.sort = 2"; $get['where'] = "WHERE exams.active='Y' AND exams.id = ".$exam_id; $exam = get($get); unset($get); $get['table'] = 'exams'; $get['columns'] = array('exams.*','ii.image as icon_image','ic.image as cover_image'); $get['join'] = "INNER JOIN images ii ON ii.table_name = 'exams' AND ii.table_id = exams.id AND ii.sort = 1 INNER JOIN images ic ON ic.table_name = 'exams' AND ic.table_id = exams.id AND ic.sort = 2"; $get['where'] = "WHERE exams.active='Y' AND exams.id != ".$exam_id; $get['order'] = 'ORDER BY exams.sort'; $exams = get($get); } ?>