here is what i have so far:
on website load, a bunch of items are add to a list in an order given in an order section of a database. i can move the list around because the list is "sortable" (jquery).
what i need:
the user rearranges (sorts) the list items, the website updates the order, which is stored in an Access database. i am lost as to how to do that. help! where do i start?
List table should have one column "order" to store the order. When user rearrange the list items, make the SQL string using primary key of table e.g.
string strSQL = "Update ITEM set order = 1 where item_id = 1;";
strSQL+ = " "Update ITEM set order = 2 where item_id = 2;";
..................................................
..........................................
Use this strSQL for bulk update your item.
it may helps you.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.