How to write Subquery in codeigniter active record for this query
Try this
<?php $query="from_id, (SELECT COUNT(id) FROM user_messages WHERE from_id=1223 AND status=1) AS sent_unread, (SELECT COUNT(id) FROM user_messages WHERE from_id=1223 AND status=2) AS sent_read"; $query_run=$this->db->select($query); $query_run->where('from_id', $member_id); $query_run->group_by('from_id'); $result = $query_run->get('user_messages'); //echo $this->db->last_query(); return $result->row(); ?>