where condition role.

Hi Coders,

i have user table with role, ADMIN AND USER now
i have a one page, that if the user login as user, he/she can view his own work while if the user login as admin he can view all user works?

any body how to implement it.


wrong condition....

PHP Code:

$this->db->where('users.fname',$this->session->userdata['logged_in']['fname'] AND 'users.role','admin');