Excluding something from a querry result...

Worker Joined: Jul 07, 2004 Posts: 192

I would like to exclude posts from Moderators forums and my Private forums from beeing displayed in my forums block... How can I do it... Is there somekind of an exclude function for the querry... ?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Find the forum id's of those 2 forums. Then, where your logic is selecting
forum_id from bb_topics
add a clause like this
WHERE forum_id NOT IN(XX,YY)
where XX and YY are the id's that you want excluded.

Posted: Mon Jan 17, 2005 9:54 am

And once again thank you very much Raven... worship