Hey guys, I have created a little CMS project.
There are several cases where I have content that needs to be able to be moved to the top or down.. etc. Right now, I just asdded a field called "order" and all my sql queries are doing "ORDER BY `order` ASC"
The way to change order is just to have the user change the number manually when editting the item.. So if you have 2 items.. one with the value 50 will be at bottom and one with value of 1, will be at the top.
I would like the user instead of having to put in a number in an input field, just be able to hit "move up" or "move down".
My question is, how would I go about this. Im having a brainfree on how to do this logically.
Thanks ahead of time!