write
insert into new_table (val1, val2)
select from old_table
val1, val2 where id=kdsaflkj
and execute it with php like any other statement
almir
ps. but checking mysql.com helps, there are lot of other interesting things
""YoBro"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
99e1q7$gv8$[EMAIL PROTECTED]">news:99e1q7$gv8$[EMAIL PROTECTED]...
> I need to know how to do it in PHP?
>
>
> ""Cal Evans"" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> : Probably on the MySQL list. This is the PHP. (This is arguments,abuse
is
> : down the hall.)
> :
> : Try:
> : http://www.mysql.com/documentation/lists.html
> :
> :
> : Cal
> : http://www.calevans.com
> :
> :
> : -----Original Message-----
> : From: YoBro [mailto:[EMAIL PROTECTED]]
> : Sent: Thursday, March 22, 2001 5:20 PM
> : To: [EMAIL PROTECTED]
> : Subject: [PHP] Move data from one MySql table to another?
> :
> :
> : Hello,
> :
> : Does anybody know where I could find out how to Move data from one Mysql
> : table to another.
> :
> : I have a query showing all the results, and I am trying to put a link at
> the
> : end of each row that says "move"
> :
> : Clicking this will move that records information to another table.
> : IE From table orders to table ordered
> :
> : Make sense?
> :
> : Please help
> :
> : --
> : Regards,
> :
> :
> : YoBro
> : -------------------------------------------------------------
> : DO NOT REPLY TO THIS VIA EMAIL
> : PLEASE USE THE NEWSGROUP
> : All emails sent to this address are automatically deleted.
> : This is to avoid SPAM!
> : -------------------------------------------------------------
> :
> :
> :
> : --
> : 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]
> :
>
>
>
> --
> 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]