Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 1 Year, 5 Months, 2 Weeks ago query for spesific forum
#1
Solved: 1 Year, 5 Months, 2 Weeks 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)