Sorting algorithm

[kostik]

Hi falks!

I'm having an interestning problem here.
There is a table with some rows, for ex.:

id name

1 Sam
2 Bob
3 Alice

4 Robin

Now I need to sort it neither by id nor name, but user-specified. For ex.

id name

4 Robin
2 Bob
1 Sam

3 Alice

The user must be enable to sort this table by moving the rows up and down.

I see only one solution here - to add a new column "sorting" with ordered numbers. The numbers must be changed as the user sorts the table. But this way looks too complex for me - is there an a better way??

Thanks!

[Anon]

hello konstantin,

i dont understand what exactly you mean
with 'user-specified'?

chris

[Anon]

I don\'t know of a better way. Specially if you have different orders for different users. You have to store the order at least somewhere anyhow.

.samuli