[6.3.1]
Number of users subscribed to board XXXX:
SELECT COUNT(*) FROM w3t_Subscribe
WHERE S_Board = 'XXXX'
Users subscribed to board XXXX:
SELECT U_Username FROM w3t_Subscribe
LEFT JOIN w3t_Users ON U_Number = S_Uid
WHERE S_Board = 'XXXX'
XXXX is the board keyword.
-----
UBB.threads beta tester / threadsdev.com moderator
Software consulting services including UBB.threads problem resolution / installs / upgrades / customization.
[This message was edited by Dave_L on August 25, 2003 at 07:30 AM.]