I am using a join table to record which category an event belongs to.
category_id | event_id
5 | 1
1 | 1
2 | 3
6 | 4
7 | 4
I need to update this table if the event categories change and I have been trying to find a quick and simple method of updating the table with the new relationships without having to jump through too many loops.
I am thinking of deleting all the existing relationships based on event_id then inserting the new ones. Any suggestions on a better solution please.