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

Dermatology & Venereology Department

This is when dermatology and its practitioners, called dermatologists, play an important role. Disease of the skin affects all age groups – infants, teenagers, adults.

Doctors :


Array
(
    [0] => stdClass Object
        (
            [user_id] => 16
            [dpId] => 0
            [firstname] => Dr. Rezaul  Islam
            [lastname] => Hira
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 46
            [view_order] => 13
            [picture] => assets/images/doctor/e826ba2dfe6e4a69958e9cd807d5da33.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] => 3
            [create_date] => 2021-06-02
            [update_date] => 
            [status] => 1
            [name] => Dermatology & Venereology
            [id] => 14
            [language] => english
            [designation] =>  Assistant Professor
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Dermatologist
            [short_biography] => 
            [specialist] => Dermatology & Venereology
            [degree] => MBBS (DMC), MCPS, FCPS (Skin & VD)
FAM ( Fellowship in Aesthetic Medicine-India)

        )

    [1] => stdClass Object
        (
            [user_id] => 30
            [dpId] => 0
            [firstname] => Dr. Parvin
            [lastname] => Sultana
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 46
            [view_order] => 13
            [picture] => assets/images/doctor/2aa698fa35591fc2b1186eb167f78435.png
            [date_of_birth] => 1970-01-01
            [sex] => Female
            [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-05
            [update_date] => 
            [status] => 1
            [name] => Dermatology & Venereology
            [id] => 28
            [language] => english
            [designation] =>  Consultant
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Dermatologist
            [short_biography] => 
            [specialist] => Medicine
            [degree] => MBBS, DDV
        )

)

Dermatology & Venereology

Dr. Rezaul Islam Hira
author01

Dermatology & Venereology

Dr. Parvin Sultana
author01

Make an appointment! Go there