getTable('patient','pat_id desc'); if($res){ $i=1; foreach($res as $pat_data) { $sql= "SELECT * FROM department WHERE department_id='".$pat_data['department_id']."'"; $rs= mysqli_query($obj->mysqli,$sql); if($rs) { foreach($rs as $data) { ?>