$d['selecteddept'] = $this->db->query("SELECT e.id as eid,d.id as depid,d.name as depname from department d INNER JOIN employee_department ed on ed.department_id=d.id INNER JOIN employee e on e.id=ed.employee_id where ed.employee_id=". $e_id .";")->row_array();
<?php foreach ($selecteddept as $dpt) : ?> <option selected="selected" value="<?= $dpt['id'] ?>"><?= $dpt['name']; ?></option> <?php endforeach; ?>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)