Hello, I’ve got three tables:
Users
Topics (foreign key: user_id)
Post (foreign key: topic_id)
I’m building a dashboard (DashboardController) and in its index (index.tpl) I’d like to access two sets of data:
- All private Topics (Topics.isPrivate = 1) made by the current user
- All Posts in public Topics (Topics.isPrivate = 0) by the current user
I was told I could use collections for this and I’ve read the Book entry on it, I just don’t understand how to get this to work. I really hope somebody can help me with this.