SELECT `user`.*, `department`.`name`, `lang`.* FROM `user_lang` as `lang` LEFT JOIN `user` ON `user`.`user_id` = `lang`.`user_id` LEFT JOIN `department` ON `department`.`dprt_id` = `user`.`department_id` WHERE `lang`.`language` = 'english' AND `user`.`user_role` = 2 AND `user`.`status` = 1 AND `user`.`department_id` = '44' ORDER BY `user`.`view_order` ASC Universal Medical College Hospital ltd.

Critical Care Units Department

Intensive care units cater to patients with severe and life-threatening illnesses & injuries, which require constant attention, close monitoring and support from highly advanced and specialized equipment and medications in order to ensure and maintai

Doctors :


Array
(
    [0] => stdClass Object
        (
            [user_id] => 22
            [dpId] => 0
            [firstname] => Dr. Arafat
            [lastname] => Hossain
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 44
            [view_order] => 13
            [picture] => assets/images/doctor/a09f14db56bedcb5222d195f5d272ecc.png
            [date_of_birth] => 1970-01-01
            [sex] => Male
            [blood_group] => 
            [vacation] => 
            [facebook] => https://www.facebook.com/umchltd
            [twitter] => 
            [youtube] => https://www.youtube.com/channel/UC5LBDsiyCXYgBqYYLj6Mr8Q
            [dribbble] => 
            [behance] => 
            [created_by] => 94
            [create_date] => 2021-07-05
            [update_date] => 
            [status] => 1
            [name] => Critical Care Units
            [id] => 20
            [language] => english
            [designation] =>  Consultant
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Consultant Critical Care
            [short_biography] => 
            [specialist] => Critical Care
            [degree] => MBBS, MD(Critical Care)
        )

    [1] => stdClass Object
        (
            [user_id] => 85
            [dpId] => 0
            [firstname] => Brig.Gen.(Prof) Dr. MHM Delwar 
            [lastname] => Hossain (Retd)
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 44
            [view_order] => 13
            [picture] => assets/images/doctor/a24058d1483de3395529cfcb97f88819.png
            [date_of_birth] => 2021-05-31
            [sex] => Male
            [blood_group] => 
            [vacation] => 
            [facebook] => https://www.facebook.com/umchltd
            [twitter] => 
            [youtube] => https://www.youtube.com/channel/UC5LBDsiyCXYgBqYYLj6Mr8Q
            [dribbble] => 
            [behance] => 
            [created_by] => 3
            [create_date] => 2021-06-15
            [update_date] => 
            [status] => 1
            [name] => Critical Care Units
            [id] => 83
            [language] => english
            [designation] =>  
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Sr.Consultant Critical Care
            [short_biography] => 
            [specialist] => Sr.Consultant Critical Care
            [degree] => MBBS, DA, MCPS, FCPS
        )

)

Critical Care Units

Dr. Arafat Hossain
author01

Critical Care Units

Brig.Gen.(Prof) Dr. MHM Delwar Hossain (Retd)
author01

Make an appointment! Go there