Pagination with sorting

[eluser]spyro[/eluser]
I think that we are getting closer.

I need the count to only total where the mrc.userid_c = a.id


I tried this

Code:

$this->db->select('a.id, a.name, a.billing_address_street,
        a.billing_address_city, a.billing_address_state, a.billing_address_postalcode,
        a.billing_address_country, a.website, a.description, ac.eighthundrednumber_c,
        ac.mechanixlooprating_c, ac.extension_c, ac.petfriendly_c, ac.womenowned_c, ac.providearide_c,
        count(mrc.userid_c = a.id) as num_reviews'
        );

and

Code:

$this->db->select('a.id, a.name, a.billing_address_street,
        a.billing_address_city, a.billing_address_state, a.billing_address_postalcode,
        a.billing_address_country, a.website, a.description, ac.eighthundrednumber_c,
        ac.mechanixlooprating_c, ac.extension_c, ac.petfriendly_c, ac.womenowned_c, ac.providearide_c,
        count(mrc.userid_c) where mrc.userud_c = a.id as num_reviews'
        );

but both gave errors.