Variable in MY_Controller

[eluser]webthink[/eluser]
Sorry didn't mean to offend but it just seemed from your questions that you were missing the fundamentals of how controllers interact with views and then later on asked how controllers interact with models (how do i use the data in an sql query?).

To be fair I hadn't actually checked the manual for examples and on looking further there isn't actually a good basic working example of how the three main components Model, View, and Controller all fit together. There probably should be. If you have a look at the video tutorials here http://codeigniter.com/tutorials/ though you'll get a good overview of how it all works.

cheers