How to update reordenated menu items in DB

[eluser]gon[/eluser]
If you start doing updates for setting every item order, what if the last query fails?

Transactions allow you to write changes only if all queries work.

If you use transactions when writing the order of every item in different queries, all the queries will be considered as an atomic operation, because they are all either done or not. So you write all the updates, or you dont write any of them if there is an error.

check the codeigniter transactions user guide, its easy to implement them. But remember that in MySQL only InnoDB tables allow the use of transactions.