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` = '38' ORDER BY `user`.`view_order` ASC Universal Medical College Hospital ltd.

Hematology Department

Hematology is the branch of medicine concerned with the study of the cause, prognosis, treatment, and prevention of diseases related to blood.

Doctors :


Array
(
    [0] => stdClass Object
        (
            [user_id] => 39
            [dpId] => 0
            [firstname] => Prof. Dr. Mahabubur
            [lastname] => Rahman
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 38
            [view_order] => 4
            [picture] => assets/images/doctor/prof-dr-mahbubur-rahman.png
            [date_of_birth] => 1988-08-09
            [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-02
            [update_date] => 
            [status] => 1
            [name] => Hematology
            [id] => 37
            [language] => english
            [designation] =>  Professor
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Haematologist
            [short_biography] => 
            [specialist] => Blood Transfusion
            [degree] => MBBS, FCPS (Haematology)
        )

)

Hematology

Prof. Dr. Mahabubur Rahman
author01

Make an appointment! Go there