MyBB Community Forums
query for spesific forum - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: query for spesific forum (/thread-213351.html)



query for spesific forum - pailul - 2017-10-04

i use plugin Last User Threads in Profile, (may be related plugin suport, but i think its general question related query language)
and i want, thread for specific forumĀ 

original code
WHERE t.visible = '1' And t.uid = '{$memprofile['uid']}'

i chage like bellow, for one spesific forum and succes
WHERE t.visible = '1' And t.uid = '{$memprofile['uid']}'And t.fid = '9' 

but i want for 4-6 forum, i try like bellow not succes
WHERE t.visible = '1' And t.uid = '{$memprofile['uid']}'And t.fid = '9' And t.fid = '10' And t.fid = '11' 

thanks

FIX

i use methode bellow

WHERE t.visible = '1' And t.uid = '{$memprofile['uid']}'And t.fid IN ('9', '10', '11', '12')

sorry but thanks