Hi,
I am bit stuck with php sorting.
I have category list which are in order form like 1,2,3,4.....9,10,11 and is stored into datbase.
what i want to do is change any number's position. e.g if i change number 9 to number 3 into database then result will be like 1,2,3,3,4.....9,10,11
how can i sort this to that new number 3 would become 3 and already 3 number change into 4, then next 4 into 5 and so on till 11. mean it should save into datbase with this new order
how can i sort this with new order and then save into database. thanks