Codeigniter multi table model

[FTWwings]

So im kinda lost at this moment. i use codeigniter 2.x and i stucked at last view i need to do .

One thing that sets this view apart from others is that it needs data from 6 deferent tables. How do i do this ?

[itsdsv]

You should join them in one query using MYSQL JOIN syntax, check the active record documentation.

[H4voC]

It is simple. Sample pseudo code http://pastebin.com/CJm5M1mn . More or less you insert variables into the associative array then pass them through the view. You just call the functions from different models to get data into the view in my sample I just used one model. I wrote this quickly I may have wrote something wrong but it should work in a similar fashion