public function save_patient($data_array, $patient_number, $date_created, $facility_code) { $o = new Patients(); $o->fromArray($data_array); $o->save(); $sql = "select id from patient_details where patient_number='{$patient_number}' and date_created='{$date_created}' limit 0,1"; $query = Doctrine_Manager::getInstance()->getCurrentConnection()->fetchAll($sql); foreach ($query as $key => $value) { $id = $value['id']; $system_patient_number = $facility_code . 'P' . $id; $sql_u = "update patient_details set system_patient_number='{$system_patient_number}' where id='{$id}'"; $q = Doctrine_Manager::getInstance()->getCurrentConnection()->execute($sql_u); } return TRUE; }