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

Thoracic surgery Department

Doctors :


Array
(
    [0] => stdClass Object
        (
            [user_id] => 35
            [dpId] => 0
            [firstname] => Prof. Dr. Kamrul
            [lastname] => Islam
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 69
            [view_order] => 13
            [picture] => assets/images/doctor/81d52135e057932d70dee5b04b10de68.png
            [date_of_birth] => 1988-04-09
            [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-08-29
            [update_date] => 
            [status] => 1
            [name] => Thoracic surgery
            [id] => 33
            [language] => english
            [designation] => Professor
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Thoracic Surgeon
            [short_biography] => 
            [specialist] => Thoracic Surgeon
            [degree] => MBBS, MS (Thoracic Surgery)

        )

)

Thoracic surgery

Prof. Dr. Kamrul Islam
author01

Make an appointment! Go there