I don't mean to be argumentative, but why would you need to do this? A key
field is usually intended to uniquely identify a row and nothing more, the
actual value of the key (whether the id is 1 or 2) *should* be immaterial.
I'm probably over simplifying this, but are you sure you really need to do
this?
Regards,
Gary H.
""Vincent P. Cocciolone"" <[EMAIL PROTECTED]> wrote in message
001001c0aeff$ce098dc0$[EMAIL PROTECTED]">news:001001c0aeff$ce098dc0$[EMAIL PROTECTED]...
> 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]
>
--
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]
