i know what you are trying to do i have done it before, just don't quite remember how
i solved the problem, but i think what i did was to create the move link with the id
of the field that you want to move, then another php file will do the stuff:
1. using the insert with the select statment you will be able to insert the row into
the new table using the id in the where clause of the select section.
2. check to ensure that the data was inserted
3. delete from oldtable where id = id passed from previous page
4. return the user to the page so that they can see that the row is no longer there.
--
On Fri, 23 Mar 2001 11:19:34
YoBro wrote:
>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]
>
>
Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
--
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]
