How to move records from one table to another

jbh

Hello. I am just wondering how I can create a loop that pulls records from a table 'affiliates' and sends them to another table.

So if there are 5 affiliates (I just want to query the field name 'username' in that table) and I want all 5 of these records moved to table 'b', how can I do that via a loop within a php page?

Thanks

groovything

 //connect 
	$connection = mysql_connect("localhost","username","password")  

	or die ("Couldn't connect to server."); 
    //select db 
	$db = mysql_select_db("database", $connection) or die("Couldn't select database."); 

// I am assuming you have some kind of search form that has multiple inputs for affiliate names labeled affiliate1, affiliate2 etc...
for ($x = 0; $x < $numAffiliates; $x++) 
{

//get desired records
$result = mysql_query ("select * from affiliates where username = '$affiliate$x'"); 
while ($row = mysql_fetch_array($result)) 
   {
   //grab values from the db
   $STRusername = $row["username"];
   $STRotherInfo = $row["otherInfo"];

//insert values into destination table
   $result2 = mysql_query ("INSERT INTO secondTable (username, otherInfo)values('$STRusername', '$STRotherInfo')"); 
   } // db record loop
} //affiliate count loop

jbh

Thank you very much.

groovything

I added logic that would enable you to feed it multiple search names

you could either have a set # of search text inputs named "affiliate1", "affiliate2", etc... and then $numAffiliates would just be hard-coded as the number of inputs.

or you could dynamically add search input fields and then pass the number of those to this script as a hidden form element named "numAffiliates"

jbh

Yeah, it worked like a charm and I see it can be enhanced for more fields.

I cannot thank you enough. I just could not figure out what I was doing wrong before.

Have a good day.

groovything

sweet! I love it when my advise is useful! :-)