Solved: 3 Years, 11 Months ago query for spesific forum
#1
Solved: 3 Years, 11 Months ago
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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)