how to do single pagination for two queries(displaying in same table)

[eluser]praveens[/eluser]
hi any body help me to do pagination for two queries

[eluser]Sawariya[/eluser]
Explain your requirement??
what is your first query and second?

[eluser]praveens[/eluser]
i have to display two tables in single page with pagination, in model i wrote 2 queries in two different function like
function1()
function2()

in controller i calling that models

Code:

$arr_data['result'] = $this->adminmodel->get_orders_amend($limit);
$arr_data['result1'] = $this->adminmodel->get_amend($limit);

so now i want to count $total_rows

in my view page all working fine but it not counting correctly

[eluser]hvalente13[/eluser]
If you add a LIMIT to your query it only gives you the LIMIT count at tops!

You have to count before adding LIMIT to your query!

Read this http://ellislab.com/forums/viewreply/432167/