Jump to the post that solved this thread.
Solved: 4 Years, 5 Months, 3 Weeks ago Latest threads/posts from one category
#2
Solved: 4 Years, 5 Months, 3 Weeks ago
Try this

$read_from_forum = " AND t.fid IN ('1','2','3','4','5')";
	$query = $db->query("
        SELECT t.*, t.tid, t.fid, t.uid, t.lastpost, t.lastposteruid, t.lastposter, t.subject, t.replies, t.views, u.username
        FROM ".TABLE_PREFIX."threads t
        LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid)
        WHERE 1=1 {$excludeforums}{$tunviewwhere}{$read_from_forum} AND t.visible='1' AND t.closed NOT LIKE 'moved|%'
        ORDER BY t.lastpost DESC
        LIMIT 0, ".$mybb->settings['portal_showdiscussionsnum']
    );


1, 2, 3, 4 and 5 adapt to your forum ID's. (not forum cat)
Reply
Jump to the post that solved this thread.


Messages In This Thread
RE: Latest threads/posts from one category - by MrBrechreiz - 2017-04-28, 01:43 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)