$this->db
->select('p.content,p.id,p.userid,p.postid,p.nodeview,p.questionid,p.groupid,u.username,u.avatarpath')
->from('posts p')
->join('users u', 'p.userid = u.id')
->where('p.userid',$user['id'])
->where_not_in('p.nodeview', array('article','pm'))
->order_by('p.datetimenumber', 'DESC')
->limit(20,$page);
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result();
}
else {
return FALSE;
}