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 [EMAIL PROTECTED] 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!!!
--
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]
