Mysql question

[InfraRedesign]

Is it possible to move up a row ?
Ex: my site displays ID's 1,2,3 but I would like to change that to 1,3,2

I havent't seen this option in PHPMyadmin but is it possible ?

[Aes]

No, it's not possible. I have a question though -- why in the world would you want to do this? I cannot think of any valid reason.

-Colin

[InfraRedesign]

if u have a large menu for example..and u want the last link to be on top

[filmfoto]

You could always add a field to your table, called something like view_order. Then all you have to do is update this view_order field as necessary and use an ORDER BY view_order clause.

Might help.




Cheers.