Hi guys. Need help on how can I show the classification of the user currently logged in using maybe SQL query or CDbCriteria. I have table with user_id and classification. If the user logged in I want to view the classification the user belonging to.
User_id | Classification
85 class I
85 class II
82 class I
81 class III
If I logged in with user_id = 85, how can I view only my classification?
I haven’t try using SQL command in view. Hope someone will help me here. Thank you.