Ok, thanks. I had been messing with that as part of my troubleshooting. I put it back to 1 for both. I also dropped the table and re-added, without setting the order_col to be a UNIQUE key, which I think was blocking the updates to the database entirely, most of the time. Now I can update some rows, but they don't update in the order I dragged them.
for example, I take the first row and drag it below the third. some of the items below the 3rd item update, but the first item in the database is still the first according to order_col and I can't move the last item at all, it always goes back to being last. Here is the output from my "fwrite" logging: this array has 0 members **************************************** Order Array 3 catID 3 orderid1 UPDATE hln_stations SET order_col=1 WHERE id=3 4 catID 4 orderid2 UPDATE hln_stations SET order_col=2 WHERE id=4 5 catID 5 orderid3 UPDATE hln_stations SET order_col=3 WHERE id=5 1 catID 1 orderid4 UPDATE hln_stations SET order_col=4 WHERE id=1 6 catID 6 orderid5 UPDATE hln_stations SET order_col=5 WHERE id=6 7 catID 7 orderid6 UPDATE hln_stations SET order_col=6 WHERE id=7 10 catID 10 orderid7 UPDATE hln_stations SET order_col=7 WHERE id=10 11 catID 11 orderid8 UPDATE hln_stations SET order_col=8 WHERE id=11 11 catID 11 orderid9 UPDATE hln_stations SET order_col=9 WHERE id=11 12 catID 12 orderid10 UPDATE hln_stations SET order_col=10 WHERE id=12 14 catID 14 orderid11 UPDATE hln_stations SET order_col=11 WHERE id=14 15 catID 15 orderid12 UPDATE hln_stations SET order_col=12 WHERE id=15 16 catID 16 orderid13 UPDATE hln_stations SET order_col=13 WHERE id=16 16 catID 16 orderid14 UPDATE hln_stations SET order_col=14 WHERE id=16 17 catID 17 orderid15 UPDATE hln_stations SET order_col=15 WHERE id=17 18 catID 18 orderid16 UPDATE hln_stations SET order_col=16 WHERE id=18 -- You received this message because you are subscribed to the Google Groups "Prototype & script.aculo.us" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/prototype-scriptaculous?hl=en.
