Just a little explanation for a beginner...

[eluser]knucklehead[/eluser]
[quote author="Colin Williams" date="1254975249"]I would aim for a single JOIN query, but another option is to just run two queries and then iterate over one and do the logic in PHP to append artists to a property of the event objects. (Looks like all you are doing in your current code is converting object notation to array notation, and adding a dimension to the array)

Either way do it in your model. That way anytime your information/data needs change, you've got just one place to make changes to (the model).[/quote]
Thanks for reply!
Yes, that's exactly what I am doing with my query results.
Thank you for clearing out some things to me =)
I couldn't resist to check out your Template Library so I think you will hear from me later =)