Help modeling assignments

[eluser]pabloheim[/eluser]
[quote author="Dam1an" date="1250481868"]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)

[/quote]

hi, thanks for comment.
i think what you suggest its going to be very useful. IM using mysql, so i could build a query iterating for each id i explode .
thanks a lot!!