I am trying to switch the id's of two rows in mysql using php - the more i read about it the more confused i get. There seems to be a lot of conflicting information. Has anybody got a definitive answer.
eg in initial state my rows are
1-Peter-22-germany
2-mary-16-iceland
3-tom-29-france
4-michael-34-greece
and then i would like to swap the id's of rows 2 and 3 so that it would look like this
1-Peter-22-germany
3-mary-16-iceland
2-tom-29-france
4-michael-34-greece
so that if i then ordered it by id i would have
1-Peter-22-germany
2-tom-29-france
3-mary-16-iceland
4-michael-34-greece