PLEASE HELP: add multimple FORUM subscriptions at once

[Andreas]

If you want to overwrite you must use UPDATE or REPLACE instead of INSERT

[btappan]

Originally Posted by KirbyDE

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 your 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]

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


EDIT: I think i am just going to delete the table entries through phpmyadmin. I can then run the queries above without problems.