> What is the best way to pull data from one table and insert into another?
insert into newmembers(name, email, whatever) select name, email, whatever
from oldmembers
> How can I delete entries from a table with a php document?
The same way you select entries.
mysql_query() can send *ANY* query to your database.
> 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)
Wouldn't it be easier to present different info to members based on their
email or lack thereof, and similarly based on their password or lack
thereof, than to mess around with shuffling all the data from table to
table?...
--
Visit the Zend Store at http://www.zend.com/store/
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
--
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]
