Hello
I found this query code in a plugin :
now, I want to know how can I limit it to a special forum
for example limit it to a forum that its FID is 2
thanks
I found this query code in a plugin :
Code:
SELECT t.tid, t.fid, t.subject, t.lastpost,
t.lastposter, t.lastposteruid, f.name,
u.usergroup, u.displaygroup
FROM ".TABLE_PREFIX."threads AS t
INNER JOIN ".TABLE_PREFIX."forums as f
ON (f.fid = t.fid)
LEFT JOIN " . TABLE_PREFIX . "users AS u
ON (t.lastposteruid = u.uid)
{$fids}
AND t.visible = '1'
GROUP BY t.tid
ORDER BY t.lastpost DESC
LIMIT
now, I want to know how can I limit it to a special forum
for example limit it to a forum that its FID is 2
thanks
