how do i write count query using CI Active Recordset

[eluser]Sumon[/eluser]

Code:

SELECT member_zip_code, count(*)
FROM `member`
group by member_zip_code

how do i write it in a model using active recordset whereas CI dont have select_count() or something similar to that.

[eluser]Sumon[/eluser]
It should be as:

Code:

$query = $this->db
                  ->select("m.member_zip_code, count(*) total")
                  ->from('member as m')
                  ->group_by('m.member_zip_code')
                  ->get();

be careful about count(*) not count(m.*)