[PHP] mySQL - Swap data in a field between two rows

[Vincent P. Cocciolone]

There must be an easy way, but it escapes me.

How can I switch the data in a feild of one row with the data in that field of
another row?

example:
row: id=1 fname=John lname=Doe
row: id=2 fname=Mary lname=Poppins
to:
row: id=2 fname=John lname=Doe
row: id=1 fname=Mary lname=Poppins
Thanks...




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]