my_model, queries and joins

[eluser]Aken[/eluser]
I love how everyone takes that so personally and offensively. It is my 100% honest opinion that the framework is out of your league if you can't understand how to solve a problem like this. This doesn't even have anything to do with CodeIgniter. How are you supposed to use a framework when you don't know the language it's written in? Would you expect to be able to use calculus if you didn't know basic arithmetic? Would you argue with the professor when he told you to take a more basic class first?

Also, I could post the 14-line solution for you, but I don't really want to now, since apparently what I say doesn't matter.