Pagination with sorting

[eluser]spyro[/eluser]
[quote author="drewbee" date="1235793126"]Nope. But I don't Understand your problem I thought we were good at the point where you said 'I get the correct number of records'.

Let's start over. Your ultimate goal of this query is to Get the account information (accounts). Is their a one-to-one relationship or one-to-many relationship with accounts_cstm? After that is joined, you simply want a count of all the records from mech_reviews_cstm to which you can order by.

I do not think active record will be your friend on this one, as a subquery is in line.[/quote]

Not a problem. So if you look at where the query started on page one I was doing a join on accounts and accounts_cstm. This gave me the correct number of results. ( Yes, this is 1 to 1 )

What we added was a Left join and count statement to get the total number of reviews related to that account. Now I only get 1 result back.