[smirkley]

Originally Posted by kh99

If you're talking about trying the last code you posted above, that won't work because the only way the condition would be true is if pm.folderid was equal to -1 and to 0. If you wanted to do it that way you'd need an OR (and add parens), like:

$pms_query_where_clouse .= " AND (pm.folderid = '0' OR pm.folderid = '-1')";

But that's actually equivalent to "AND pm.folderid IN (0, -1)", which is what you get by removing the NOT.

Forgot to return to this, but yes you are correct. My attempt didnt work as you suggested. Didnt prune anything in tests.

I will try your suggestion next and report back the results.

Is there a preferred methed? Use the OR or use the AND without the NOT?