Re: Implode?

From: Date: Tue, 27 Feb 2001 22:49:21 +0000
Subject: Re: Implode?
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-41900@lists.php.net to get a copy of this message
> 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

« previous php.general (#41900) next »