question on db

[eluser]mistress_shiira[/eluser]
hi guys!
im still not comfortable with CI so pls pardon my otherwise simple questions.
im working on a certain admin page where that particular page shows the result from a query that i did.actually, what im confused here is how do i replicate the same thing that i did in CI?i mean,doing a query and echoing it as a table of results?
if i insert a function in my main controller for achieving that,how am i going to utilize the function in my view?

thanks again for any help on this...