FuelPHP Forums

In first, sorry, i'm not very good for write in english...

I use the relation "ManyToMany" : An "User" can have several "Category", and a "Category" can have several "User".

The table for this relation is like (users_categorys) : "id", "id_user", "id_category"

I have a form for create/update an User, in this form i use several "SELECT" input for add/remove "Category". I use js for add/remove "SELECT" from the DOM and their name is like : "categories[1], categories[2], etc..." the number is dynamic (count of "SELECT")

In the controller i do this :

<code>

<?php

$myUser->categories[] = array();  // I reset all relations

foreach(Input::post('categories') as $postCategory) {

$myUser->categories[] = Model_Category::find($postCategory);

}

$myUser->save();

</code>

It's ok, that work. But ...

If i create an User and add 2 categories to this user, the table is like :

id id_user id_category

1 1 1

2 1 2

And now, i want to update this User for edit other fields, but i keep his 2 categories, the table :

id id_user id_category
3 1 1

4 1 2

He delete 2 rows for add same rows. So he delete old relations for add new relation even if it's the same relation. 

I think it's normal because i do : $myUser->categories = array();

But it's not very optimized ? I right ?

If yes, what is the best solution for my problem ? 

Perhaps use the attribut "id" in the table "users_categorys", but how can i have access to this ?

Thank's for read my post

Good day !

Syntaxlb