how to pass query result from controller to view and display it?

[eluser]Alpha[/eluser]
tnx, i've read that. what i am planning is to prepare the data through sql query at the controller side then pass it to view rather than the view file directly doing the sql query and displaying it