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

Nephrology Department

Nephrology is the subspecialty of internal medicine that focuses on the diagnosis and treatment of diseases of the kidney. Because the kidney performs so many critical functions, nephrologists maintain expertise in primary kidney disorders, but also

Doctors :


Array
(
    [0] => stdClass Object
        (
            [user_id] => 34
            [dpId] => 0
            [firstname] => Dr. Rana Mokaram
            [lastname] => Hossain
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 66
            [view_order] => 13
            [picture] => assets/images/doctor/427ce242a864baabc1f33e3bff96e21f.png
            [date_of_birth] => 1988-03-09
            [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-14
            [update_date] => 
            [status] => 1
            [name] => Nephrology
            [id] => 32
            [language] => english
            [designation] =>  Associate Professor
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Nephrologist 
            [short_biography] => 
            [specialist] => Nephrology
            [degree] => MBBS, CCD, MD (Nephrology)
        )

    [1] => stdClass Object
        (
            [user_id] => 100
            [dpId] => 0
            [firstname] => Dr. Kowser Hossain
            [lastname] => Chowdhury
            [email] => UMCH@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 66
            [view_order] => 21
            [picture] => assets/images/doctor/6d9f1c23585381cf52fd1cb4a2b9cbd6.png
            [date_of_birth] => 2021-07-03
            [sex] => Male
            [blood_group] => 
            [vacation] => 
            [facebook] => 
            [twitter] => 
            [youtube] => 
            [dribbble] => 
            [behance] => 
            [created_by] => 94
            [create_date] => 2021-08-29
            [update_date] => 
            [status] => 1
            [name] => Nephrology
            [id] => 99
            [language] => english
            [designation] => Consultant 
            [address] => 
74G/75,New Airport Road
(Beside Mohakhali Flyover), Mohakali
(Opposite of RAOWA)
Dhaka 1215
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Consultant  
            [short_biography] => 
            [specialist] => Nephrologist
            [degree] => 

MBBS, MD( Nephrology 

) [2] => stdClass Object ( [user_id] => 106 [dpId] => 0 [firstname] => Dr. Maksuda [lastname] => Moni [email] => Maksuda@umchltd.com [password] => 81dc9bdb52d04dc20036dbd8313ed055 [user_role] => 2 [department_id] => 66 [view_order] => 21 [picture] => assets/images/doctor/cc5c4a7d2129ff696f614738ead8824e.png [date_of_birth] => 2021-07-04 [sex] => Male [blood_group] => [vacation] => [facebook] => [twitter] => [youtube] => [dribbble] => [behance] => [created_by] => 94 [create_date] => 2021-08-29 [update_date] => [status] => 1 [name] => Nephrology [id] => 105 [language] => english [designation] => Assistant Professor [address] => 74G/75,New Airport Road (Beside Mohakhali Flyover), Mohakali (Opposite of RAOWA) Dhaka 1215 [phone] => 09612808080 [mobile] => 01841480000 [career_title] => [short_biography] =>

MBBS, MD (Nephrology)

 

[specialist] => [degree] => ) )

Nephrology

Dr. Rana Mokaram Hossain
author01

Nephrology

Dr. Kowser Hossain Chowdhury
author01

Nephrology

Dr. Maksuda Moni
author01

Make an appointment! Go there