pls help multiple update

[eluser]Fahad Alrahbi[/eluser]
Hello ,all



i have problem with mysql multiple update



i have categories table and cat_order row

in my views i have
// while
<input type='text' name='order[]' value='{$row.cat_order} />
//end while
<input type='submit' value='update order' />


if i change order for 2 rows i want the old order of row number 1 will go to row number 2 and the old order for row number 1 will go to row number 1



i dont know if you understand me or not .