![]() |
query help please
I have a need on my site where I manually subscribe users to certain forums (not individual threads) by using the queries below:
Examples: To subscribe UserID 12 to ForumID 34 using immediate updates: [sql]INSERT INTO subscribeforum (userid, forumid, emailupdate) VALUES (12, 34, 1)[/sql] To subscribe ALL users to forum ID 34 using immediate updates: [sql]INSERT IGNORE INTO subscribeforum (userid, forumid, emailupdate) SELECT userid, 34 AS forumid, 1 AS emailupdate FROM user[/sql] this gets time consuming when their are many forums to subscribe them to. Is there a way I can specify more than just one forum ID like the above? like instead of just 34, also specify 35,36,38,39 in each of the two queries above? Thanks for your help! |
All times are GMT. The time now is 11:47 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|