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

General Medicine Department

General Medicine. This Department deals with adult medical conditions which do not involve any surgical procedures. It is also known as internal medicine. Common conditions which are seen in this department include diabetes mellitus, high blood press

Doctors :


Array
(
    [0] => stdClass Object
        (
            [user_id] => 84
            [dpId] => 0
            [firstname] => Dr. Afsana
            [lastname] => Rahaman
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 64
            [view_order] => 13
            [picture] => assets/images/doctor/7b79c22de73c7826299d21ee0e11496f.png
            [date_of_birth] => 1988-05-31
            [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] => General Medicine 
            [id] => 82
            [language] => english
            [designation] => Associate Professor
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Consultant Medicine
            [short_biography] => 
            [specialist] => Medicine
            [degree] => 	 MBBS, FCPS(Medicine)
        )

    [1] => stdClass Object
        (
            [user_id] => 112
            [dpId] => 0
            [firstname] => Dr. Mohammad
            [lastname] => Ashraful Alam
            [email] => Asraful@umchltd.com
            [password] => 45022c8b0e0c865f984e442a09b8fdee
            [user_role] => 2
            [department_id] => 64
            [view_order] => 21
            [picture] => 
            [date_of_birth] => 2021-10-10
            [sex] => Male
            [blood_group] => 
            [vacation] => 
            [facebook] => 
            [twitter] => 
            [youtube] => 
            [dribbble] => 
            [behance] => 
            [created_by] => 94
            [create_date] => 2021-10-10
            [update_date] => 
            [status] => 1
            [name] => General Medicine 
            [id] => 111
            [language] => english
            [designation] => Assistant professor
            [address] => 74G/75,New Airport Road
(Beside Mohakhali Flyover), Mohakali
(Opposite of RAOWA)
Dhaka 1215
            [phone] => 10667
            [mobile] => 01841480000
            [career_title] => Diabetologist & Medicine Specialist
            [short_biography] => 
            [specialist] => Diabetologist & Medicine Specialist
            [degree] => 

MBBS MPH,CCD (Birdem)

) )

General Medicine

Dr. Afsana Rahaman
author01

General Medicine

Dr. Mohammad Ashraful Alam
author01

Make an appointment! Go there