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

Urology Department

Urology is a part of health care that deals with diseases of the male and female urinary tract (kidneys, ureters, bladder and urethra). It also deals with the male organs that are able to make babies (penis, testes, scrotum, prostate, etc.).

Doctors :


Array
(
    [0] => stdClass Object
        (
            [user_id] => 67
            [dpId] => 0
            [firstname] => Prof. Maj. Gen. Md. Shahidul
            [lastname] => Islam (Retd)
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 61
            [view_order] => 5
            [picture] => assets/images/doctor/16d74ef566141c6ec6e2fd455001f9a6.png
            [date_of_birth] => 1988-06-10
            [sex] => Male
            [blood_group] => 
            [vacation] => 
            [facebook] => https://www.facebook.com/umchltd
            [twitter] => 
            [youtube] => https://www.youtube.com/channel/UC5LBDsiyCXYgBqYYLj6Mr8Q
            [dribbble] => 
            [behance] => 
            [created_by] => 80
            [create_date] => 2021-05-30
            [update_date] => 
            [status] => 1
            [name] => Urology
            [id] => 65
            [language] => english
            [designation] =>  Professor
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Urologist
            [short_biography] => 
            [specialist] => 	
Urology
            [degree] => FCPS (Urology), FCPS (Surgery), MCPS, MBBS

        )

    [1] => stdClass Object
        (
            [user_id] => 24
            [dpId] => 0
            [firstname] => Dr. Ahmed
            [lastname] => Shorif
            [email] => patientcare@umchltd.com
            [password] => d41d8cd98f00b204e9800998ecf8427e
            [user_role] => 2
            [department_id] => 61
            [view_order] => 13
            [picture] => assets/images/doctor/b0e6b22d18ff60b9376a50635135ba27.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] => Urology
            [id] => 22
            [language] => english
            [designation] =>  Assistant Professor
            [address] => 74G/75,Peacock Square
Dhaka-1215, Bangladesh
            [phone] => 09612808080
            [mobile] => 01841480000
            [career_title] => Urologist
            [short_biography] => 
            [specialist] => Urologist
            [degree] => MBBS, MS(Urology)
        )

)

Urology

Prof. Maj. Gen. Md. Shahidul Islam (Retd)
author01

Urology

Dr. Ahmed Shorif
author01

Make an appointment! Go there