You don't understand my problem. I need to be clearer.
The ORDER BY is not the issue.
The records are in a particular order in the DB. With the ORDER BY I get them in the right order on my screen. I want to insert a new record somewhere between. The place is determined by a key. How to choose the value for the key?
10 direction 1
20 direction 2
30 direction 3
Need to add a direction between key 20 and 30.
Ok you say, Give the key a value of 25. Thats ok, but I don't know how many extra directions needs to be added so maybe 9 extra couldn't be enough.
The key's needs to be changed very often, and that gives a lot of programming, and not foolproof I think.
So I need another way to maintain the keys.
I hope this clarifies my problem.
Thnx in advance,