Sortable list: How do I save my new list order to mySQL db?
So I can re-sort a list OK, but because I have only scratched the surface on jQuery/AJAX/mySQL - I could use some advice/help on storing my re-sorted list back to my db table.
1. I pull a list of elements from the database table initially. The table has a column for "listorder", numbered 0 - x"
2. using jQuery.ui sortable, I rearrange the list elements on the page
now I want to store the new order of elements in the database via a SQL UPDATE statement.
Is this the right method? If so, what jQuery functions do I use and how?