public function get_curriculum_info_by_mc_id($mc_id) { $stmt = $this->driver->query("SELECT\n\tcu_name,\n\tic_name,\n\tico_name,\n\tid_name,\n\tmc_grade,\n\tmc_number,\n\tmc_id,\n\tmc_year\nFROM\n\tmg_curriculum\nINNER JOIN info_curriculum ON mg_curriculum.cu_id = info_curriculum.cu_id\nINNER JOIN info_discipline ON mg_curriculum.id_id = info_discipline.id_id\nINNER JOIN info_college ON mg_curriculum.ico_id = info_college.ico_id\nWHERE\n\tmc_id = " . intval($mc_id)); $rt = $stmt->fetchAll(\PDO::FETCH_ASSOC); $stmt->closeCursor(); return isset($rt[0]) ? $rt[0] : NULL; }