Topic: SWAP two PRIMARY keys

[DiscoTrio]

So im making a php button to click (like an up or down arrow) to re-order a table but first I need a way to re-assign the primary key 'id' that is auto-increment.

Heres a quick look at the table:

id	media	title	content	text
1	photo	Sample item 1	http://media-cdn.tripadvisor.com/media/photo-s/00/...	Lorem ipsum dolor sit amet, consectetur adipiscing...
2	video	Sample item 2	media/himmler-poznan-large.flv	In quis nisi tellus, ut gravida elit. Sed aliquet,...

So anyways see the id?  Its auto increment and primary...  I need a sql statement to switch the two numbers that I can run from php variables.

Thank you.

[premiso]

You should be able to run an UPDATE on the primary and auto_increment id, albiet it is generally not recommended, instead it would be recommended to have a separate column for "order" and then order it by that and you can use that to display it.