Best Practice Suggestion :: Reorder rows based on user input

[duckduckgoose]

Hi there,

I print out a table based on a mysql query. I want the user to be able to enter in a number in order to sort the rows according to their priority (like the Netflix queue list 😉 ) .

What's the best way to do this? Is there a tutorial for something similar that's been done?

Thanks!