gistfile1.mkd

Before

id	name	help	exclusive	sort	lft	rght	parent_id	created	modified	deleted
1	Products	(null)	0	0	1	16	0	0000-00-00 00:00:00	0000-00-00 00:00:00	0
2	Hardware	(null)	0	0	2	15	1	0000-00-00 00:00:00	0000-00-00 00:00:00	0
3	Hinges	(null)	0	0	3	4	2	0000-00-00 00:00:00	2010-10-09 18:53:16	0
4	Locks	(null)	0	1	5	10	2	0000-00-00 00:00:00	2010-10-09 18:53:16	0
5	Cylindrical Locks and Strikes	(null)	0	0	6	7	4	0000-00-00 00:00:00	2010-10-09 11:33:41	0
6	Mortise Locks and Strikes	(null)	0	1	8	9	4	0000-00-00 00:00:00	0000-00-00 00:00:00	0
7	Flush Bolts	(null)	0	2	11	12	2	0000-00-00 00:00:00	2010-10-09 18:53:16	0
8	Rim Exit	(null)	0	3	13	14	2	0000-00-00 00:00:00	2010-10-09 18:53:16	0

gistfile2.mkd

After

id	name	help_text	exclusive	sort	lft	rght	parent_id	created	modified	deleted
1	Products	(null)	0	0	99	122	0	0000-00-00 00:00:00	0000-00-00 00:00:00	0
2	Hardware	(null)	0	0	100	121	1	0000-00-00 00:00:00	0000-00-00 00:00:00	0
3	Hinges	(null)	0	0	99	100	2	0000-00-00 00:00:00	2010-10-09 18:53:16	0
4	Locks	(null)	0	1	107	112	2	0000-00-00 00:00:00	2010-10-09 18:53:16	0
5	Cylindrical Locks and Strikes	(null)	0	0	85	86	4	0000-00-00 00:00:00	2010-10-09 11:33:41	0
6	Mortise Locks and Strikes	(null)	0	1	108	109	4	0000-00-00 00:00:00	0000-00-00 00:00:00	0
7	Flush Bolts	(null)	0	2	60	61	2	0000-00-00 00:00:00	2010-10-09 18:53:16	0
8	Rim Exit	(null)	0	3	117	118	2	0000-00-00 00:00:00	2010-10-09 18:53:16	0

gistfile3.php

$this->ProductFolder->reorder(array(
	'id' => $id,
	'field' => 'ProductFolder.sort'
));