[Mfn_ofc]

@Mfn_ofc,

Some questions.  What version of CI are you using? What version of MySQL are you using?  Do you have direct access to the database?  You could create a database view that will have all the necessary information that you need.  Then in your code all you have to do is call the view.

Hi, I'm using the 3.1.11 version of CI and the 5.7.33 version of MySQL.  ( on this template https://codecanyon.net/item/class-ease-e...m/29109477 ). Yes I have a direct access to the DB. The problem is, i'm not expert with CI, so I don't really know how to do that. But i'll try the db view method. thx