Help modeling assignments

[eluser]Dam1an[/eluser]
Jedd is pretty much spot on
Also, seeing as this will be abstracted in a model, it doesn't matter is it is hard (which I don't think it is), as you could pass in an array of user IDs and loop through them doing each insert, or a comma seperated string, explode it and loop through etc

And if you're using MySQL, you can even do multiple inserts in a single query, so it's no extra queries, syntax is something like

Code:

INSERT INTO `assignment` (`task_id`, `member_id`) VALUE (30, 1), (30, 4), (30, 8)