To subscribe UserID 12 to ForumID 34 using immediate updates:

INSERT INTO subscribeforum (userid, forumid, emailupdate) VALUES (12, 34, 1)


To subscribe ALL your 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

forgive me for not understanding this, but i am trying to run these queries using OVERWRITE in place of insert and am getting a sytax error. I don't care what my users current subscriptions are, I need to overwrite them all and subsribe them to the forums I indicate. I basically need it spelled out to me how to write out these two queries. the second one to subsribe ALL my current users to forum id 12 and the second to subscribe new users one by one as they register to forum id 12. Thanks for your help. Ill get this on my own one day

#If you have any other info about this subject , Please add it free.#

Your name: E-mail: Telphone: Your comments: If you have any other info about need quick help with query , Please add it free.