operations on result set ?

[eluser]Zeeshan Rasool[/eluser]
hello dear fellows,
I am in little problem that i need to implement some operations on result set. How can we do it in CI? i mean i have a result set after a long query getting result from multiple tables so can i make pagination on it . I got a solution that we can copy all results into another new table and then do what we need but results can be so much ... any idea ?
very thanks ...

[eluser]bigtony[/eluser]
It would help if you told us what 'operations' you are wanting to do.

[eluser]Zeeshan Rasool[/eluser]
[quote author="bigtony" date="1258038704"]It would help if you told us what 'operations' you are wanting to do.[/quote]
I need to implement paging on selected result set.

[eluser]bigtony[/eluser]
[quote author="zEsHaN" date="1258041315"]I need to implement paging on selected result set.[/quote]
And you have or haven't tried to use the [url="http://ellislab.com/codeigniter/user-guide/libraries/pagination.html"]Pagination Class[/url]?

[eluser]Zeeshan Rasool[/eluser]

And you have or haven’t tried to use the Pagination Class?

But how can we do it i mean i am getting result from two tables with UNION ALL function to union the two tables so how can we put limit on result set? We off course have to save it in a table if we want to make a regular call from pagination