Log in

View Full Version : help with a query please.


chrispadfield
03-07-2001, 10:21 PM
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:


$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?

03-08-2001, 10:11 AM
suggestions??? please :)