Originally Posted by Sirdude
Code
SELECT COUNT *
FROM ubbt_WATCH_LISTS
WHERE WATCH_ID = XX
AND WATCH_TYPE = 'f'

XX - the forum id you are concerned with

SD, excellent.

I had made some progress and was working on getting it refined it to get just the count..

Here's where I was just now..

Code
SELECT USER_ID, WATCH_ID, WATCH_NOTIFY_IMMEDIATE, WATCH_TYPE
FROM ubbt_WATCH_LISTS, ubbt_FORUMS
WHERE FORUM_ID = "20" AND WATCH_TYPE = "f"

I like yours better! smile

Last edited by Island Piper; 11/01/2007 4:27 PM.
Dunsire Bagpipe Forums