btappan
08-16-2005, 05:31 PM
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:
INSERT INTO subscribeforum (userid, forumid, emailupdate) VALUES (12, 34, 1)
To subscribe ALL users to forum ID 34 using immediate updates:
INSERT IGNORE INTO subscribeforum (userid, forumid, emailupdate) SELECT userid, 34 AS forumid, 1 AS emailupdate FROM user
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!
Examples:
To subscribe UserID 12 to ForumID 34 using immediate updates:
INSERT INTO subscribeforum (userid, forumid, emailupdate) VALUES (12, 34, 1)
To subscribe ALL users to forum ID 34 using immediate updates:
INSERT IGNORE INTO subscribeforum (userid, forumid, emailupdate) SELECT userid, 34 AS forumid, 1 AS emailupdate FROM user
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!