Join Table being wiped.

Hi Guys,

I've got a HABTM relationship between subcategories and resources.
There is a resources_subcategories join table. I've written a method
on subcategories that changes the order field in a record by
decrementing it. It's a bit like the tree behaviour (which I may
resort to if I cannot get this to work).

function up($id = null, $order = null) {
if (!$id or !$order) {
$this->Session->setFlash(__('Invalid id or order number', true));
$this->redirect(array('action'=>'index'));
}
// Create an array of the image table contents of IDs and Orders.
$conditions = array(
'fields' => array('id','order'),
'order' => 'Subcategory.order ASC'
);
$subcategories = $this->Subcategory->find('all', $conditions);
// Set the direction for the image to travel (up)
$delta = -1;
// index = the array item you want to move
// delta = the direction and number of spaces to move the item.
$index = $order -1;
$index2 = $index + $delta;
// Move the elements in the array
$temp_item = $subcategories[$index2]['Subcategory']['order'];
$subcategories[$index2]['Subcategory']['order'] =
$subcategories[$index]['Subcategory']['order'];
$subcategories[$index]['Subcategory']['order'] = $temp_item;
// Write it all back to the database
foreach ($subcategories as $subcategory):
$this->Subcategory->save($subcategory, false, array('id',
'order'));
endforeach;
$this->redirect(array('action' => 'index'));
}

This all works perfectly except for one thing. Each time this method
is run the entire contents of the join table is erased. I need an
idiot check. Can anyone see what it is I am doing wrong? Thanks in
advance for any help anyone can offer.

Adam.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php