row reordering.. save state to db and reload state from db??

row reordering.. save state to db and reload state from db??

kevincabrititkevincabritit Posts: 1Questions: 0Answers: 0
edited December 2013 in Plug-ins
Hello.
I got row Reordering plugin to work on a website with the jeditable plugin..
I can reorder rows of the table perfectly but i cant seem to save them to the db in which order they are and when the table is reloaded to load that saved state
For example id is 1,2,3.. i drag and drop 3 up to make it 1,3,2 which is fine
What's the best way to save the state and reload it

The id of each td is using a counter +1 in a do while loop in classic asp.

The first way i did was a simple up and down api which checks the grouping id and displays it in order.. but i switched over to a drag and drop

Is there a way to send a ajax request to the database to save the new state of the table whenever a drag and drop been made?


thanks
This discussion has been closed.