do it in your query.
sort by #form.order_by_field#
Sorry.. I didn't describe what I need as well as I thought I had.
Say I have a table for articles that all appear on a page:
ArticleID Title Content SortOrder Date 1 Title A Content A 3 2012-07-07 2 Title B Content B 1 2012-07-09 3 Title C Content C 4 2012-07-17 4 Title D Content D 2 2012-07-27
On the page that displays these articles, they appear in order from top to bottom:
But someone wants to rearrange the order in which they appear.
I prefer a drag n drop approach, but if that isn't possible/feasible, I'll appreciate suggestions.
1 person found this helpful
Put a JQuery table sorter on it. It's pretty straight fwd. I don't think you want to bounce back to the server to effect some sorting for the UI, if possible: just do it on the UI.
The client wants to be able to save the new sort order to the database. This is for a very rudimentary CMS to affect the sort order of articles on the publicly viewed pages.
A co-worker suggested using the jQuery-UI for the sort, and AJaX to submit the new sort order on every change.