Codeigniter - how to use the foreign keys from one table to look for the id's of another table.
- by Drew
I'm having a problem trying to wrap my head around how to query the database to retrieve the foreign keys in my Nav table and then using those to find the id's in the NavItem table. Can someone point me in the right direction or give me some pointers? i'm not even sure if this should be done in the model or the controller!
Thanks in advance