[eluser]Pascal Kriete[/eluser]
Hey dimethroxy,
The native way of doing this is to use libraries, helpers, and models. A combination of those can do the job 99% of the time.
In this case it's probably easiest to have a model that contains the query, and then use a a helper (or view) to format it as you like.
So in the page views you just have:
Code:
<?= last_ten_comments() ?>
Welcome to CodeIgniter.