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

Respiratory Medicine Department

Respiratory medicine is concerned with the diagnosis and treatment of a wide variety of diseases of the airway and lungs, their linings and blood vessels, and the muscles and nerves required for breathing

Doctors :


Array
(
    [0] => stdClass Object
        (
            [user_id] => 31
            [dpId] => 0
            [firstname] => Dr. Syed Rezaul
            [lastname] => Haque
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 60
            [view_order] => 13
            [picture] => assets/images/doctor/c11d618df249f2a031a4510e883839d2.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] => 81
            [create_date] => 2021-06-12
            [update_date] => 
            [status] => 1
            [name] => Respiratory Medicine
            [id] => 29
            [language] => english
            [designation] =>  Associate Professor
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Medicine & Chest Specialist
            [short_biography] => 
            [specialist] => Respiratory Medicine
            [degree] => MBBS (DMC), MD (Chest), MCPS (Medicine)DTCD (Chest), FCCP (USA), BCS (Health)

        )

    [1] => stdClass Object
        (
            [user_id] => 36
            [dpId] => 0
            [firstname] => Dr. Goutam
            [lastname] => Sen
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 60
            [view_order] => 13
            [picture] => assets/images/doctor/d8f1d1a910102d7b8c855cb535140d29.png
            [date_of_birth] => 1988-05-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] => Respiratory Medicine
            [id] => 34
            [language] => english
            [designation] =>  Consultant
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Medicine & Chest Specialist
            [short_biography] => 
            [specialist] => Respiratory Medicine
            [degree] => MBBS, MD(Chest Medicine)
        )

    [2] => stdClass Object
        (
            [user_id] => 47
            [dpId] => 0
            [firstname] => Dr. Md. Zakir Hossain
            [lastname] => Sarkar
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 60
            [view_order] => 13
            [picture] => assets/images/doctor/66f2b06aa3c9a04b21eb61d7ee6c92f9.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-10-16
            [update_date] => 
            [status] => 1
            [name] => Respiratory Medicine
            [id] => 45
            [language] => english
            [designation] =>  Associate Professor
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Medicine & Chest Specialist
            [short_biography] => 
            [specialist] => Respiratory Medicine
            [degree] => MBBS, DTCD, MD (Chest)



        )

)

Respiratory Medicine

Dr. Syed Rezaul Haque
author01

Respiratory Medicine

Dr. Goutam Sen
author01

Respiratory Medicine

Dr. Md. Zakir Hossain Sarkar
author01

Make an appointment! Go there