Swap 2 Records From Table

[ID]

Hi for all,

i want to swap 2 records , i have a table

ID	Name	Age
1	John	22
2	Shahzad	23
3	Khan	20

My Question :
i want to change the postion of Record 3 with Record 2 , mean the all value's of record2 & record3 swaps each others.Some one help me ..

[Join us @ facebook]

Swapping/changing identification records on a table is not correct. Are you sure you want to do this?

[Free WordPress Themes]

yes it's better not to do that, if you table is small you can read the whole table with php and then it's possible to change the position while writing the table data back to the db in a new order... but don't think about that if you table has more xxx records

[Guest]

[36.302]

Googlebot, Yahoo crawler, Gigabot