Implode?

What is the best way to pull data from one table and insert into another? How can I delete entries from a table with a php document? The gist of what I'm trying to accomplish is this. This is somewhat of a detailed outline, so please bear with me. 1. I have one table (members) that has all the old data. 2. I'm am going to send an e-mail to every entry in that table that has an e-mail address and have a link for them to follow to a PHP page. Any entry that does not have an e-mail address, will be moved over with a different (but similar) PHP script that will do a mass search and move of that data to the new table (memberdetail) 3. That PHP page will ask for there name and e-mail address then display a list of matching results to edit. 4. The edit page will pull data from (members) and insert then updated info into a new table (memberdetail). Password protected. Unless you know the password for that information, it will error and stop (exit () ). 5. If the insertion is successful, I want it to open a new window (if statement that contains target="_blank") which will display the new data and then the old page will refresh itself to a new page (if statement with a meta tag). If not, I want it to error and stop. (exit() ). I have already implemented anti-duplication into our new insert script (for memberdetail). The new table (memberdetail) gets scanned for duplicate information in 5 fields (but can easily but expanded to cover more then that) before it inserts data. If it finds duplicate information it displays it with an option to accept it. (password protected). If accepted (with proper password) it will delete the old information (from members) and refresh the page while opening the new information in a new window. 6. The refreshed page will be passed an variable (id) from the old table (members) and delete the entry (from members). 7. Lastly, it will refresh and pass the name and e-mail address from step 3 and display any remaining matches if any. 8. If there were any results from the search in step 7, then it will do step 4 again. If no remaining entries it will error and stop. (exit () ) Doing it this way will help us clean up our old information and get more current information for our new website. Anything that is not moved over will be erased after a couple of months. That should give them plenty of time to update and move the old data to the new site. Thanks. Kenneth R Zink II Hellcat1@S-Series.Org ICQ# 5095094 '87 GMC S-15 Ext. Cab (Hurricane) ...BBC 524 being built !!! http://www.s-series.org/htm/windstorm/project-windstorm.htm '85 Chevy S-10 Blazer (FireStorm) ...Soon to be 3.4L SFI !!! http://www.s-series.org/htm/firestorm/firestorm.htm '84 Oldsmobile Delta 88 Delta 88 Royal Brougham. Racing by the grace of God!!!