I managed to get this right by changing the syntaxt I am using on the trigger. I am now using the following to acheive my goal:ZillaConsulting wrote: This answer partly meets my needs going forwards, but what would meet my needs completely is the ability to include multiple insert statements in the trigger as I would like to autosubscribe new users to multiple forums. Any suggestions on the syntax to use to achieve this?
Code: Select all
INSERT INTO phpbb_forums_watch VALUES (2, NEW.user_id, 0), (21, NEW.user_id, 0)