help with a query please.

[chrispadfield]

I am trying to work this out.

I want to select some threads from the thread table under certain conditions but want to add the extra condition that the thread must be in a forum that the user has permissions to see. See what i mean?

now this:

PHP Code:

$getperms=getpermissions($thread['forumid'],-1,-1,$foruminfo['parentlist']); 


gets the forum permission for a thread i think, but i am not sure how to include this into the query as a WHERE.

Basically i am listing say 25 threads on a page but only want threads that a general person can view (ie non private ones)

any ideas?