Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Load the category list to the forum frontpage
- function loadCategoryList() {
- $this->db->select('forumCategory.id as categoryID, category, description, forumThread.id as threadID');
- $this->db->where('forumCategory.approved', 'yes');
- $this->db->join('forumThread', 'forumThread.fk_forumCategory = forumCategory.id');
- $this->db->group_by('categoryID');
- $loadCategory = $this->db->get('forumCategory');
- return $loadCategory->result();
- }
Add Comment
Please, Sign In to add comment