[eluser]Michael Wales[/eluser]
wow...
uhm - yes, you must write your own code.
Let's say you want to have dinner and each night you want to eat something - do you have to cook it?
In all seriousness, if it's the same SQL query you could just throw it in a model - but then, why would you have multiple controllers - sounds like a one page site to me.
I think you just need to do some reading through the user guide and determine your actual question/needs - this is a fruitless discussion.