[mattclarke]

I'm trying to integrate my vBulletin forum into my main site's search engine and would like to write a MySQL query to locate posts containing a particular keyword. I'm using the following query:

PHP Code:

SELECT title, threadid FROM post WHERE title LIKE '$q' OR pagetext LIKE '$q' AND visible ='1'; 


This works, however, it also shows posts from my moderators forum which I do not wish to reveal to standard users. I've rummaged around in the database and in the source code but I can't figure out the correct query to use to prevent these being shown.

I'd be massively grateful if someone could please give me a pointer.

Many thanks,
Matt