function get_poster_rank($name) { $this->db->select('name, COUNT(*) as posts'); $this->db->group_by('name'); $this->db->order_by('posts', 'desc'); $tmp = $this->db->get('posts'); $rank = 1; foreach ($tmp->result() as $item) { if(strcasecmp(urldecode($item->name), $name) == 0) return $rank; $rank++; } return -1; }