Add additional column to many-to-many join table in Doctrine 1 -

i set many many relationship between orders , sets. order can contain many sets , different sets can belong different orders. because can set amount set in order there should additional column amount. e.g. order can consist of 5 x "set a" , 10 x "set b".

this schema of join table:

orderset:columns: amount: integer order_id:   type: integer   primary: true set_id:   type: integer   primary: true 

works fine far, don´t know how can set value of amount column.

this how save order / set-order relationship:

public function saveorder($data){     $tempsets = $data->sets;     $order = new order();     unset($data->sets);     $order->merge((array) $data);      foreach($tempsets $set){         $q = doctrine_query::create()         ->from('set s')         ->where('s.id = ?', $set->id);         $set = $q->fetchone();         $order->sets->add($set);     }     $order->save(); } 

how can set amount of each set?

many many thanx help. cheers, florian

ah found post: nhibernate: many-to-many relationship field in relationship table

they say... treat relation table entity.

now thats way works:

public function saveorder($data){     $tempsets = $data->sets;     $order = new order();     unset($data->sets);     $order->merge((array) $data);     $order->save(); //save order first make order id available      foreach($tempsets $set){                  $orderset = new orderset(); //create object of class representing relation table         $orderset->order_id = $order->id;         $orderset->set_id = $set->id;         $orderset->amount = $set->amount;         $orderset->save();     } } 

hope can else too.

cheers, florian