Hi, I'm working on a site that has all it's page structure in a DB table : it's a hierarchy of parents and children that form a tree structure. I'm trying to find the best design to be able to easily change the order in which the siblings are outputted. I need to be able to set an arbitrary order, for example, change this 1 Aaa 2 Bbb 3 Ccc into this : 1 Bbb 2 Aaa 3 Ccc The best I could think off is to create a column called 'ordered', and put a number in it for each row : 1, 2, 3, etc. The problem is each time I want to change the order (increment or decrement the number), I have to check all the other siblings to see if there is any overlap. Does anyone have a more elegant and simple design ? Thanks.