Problem copying a table, plz help

[ukscotth]

Hi,

 

Im trying to copy all data from one table into another while changing a few things on the fly. 

 

Basically I have a social networking site and i have a table which stores whos friends with who but I need to store the information in a different way, hence the new table.  The problem is with the code im using below it only copies one record for each member e.g if fred has 50 friends its only copying the data for 1 of them.

 

Hope that makes sens and hope someone can help, heres the code :

 

 

<?php 
include("include/config.inc.php");

$users = mysql_query("SELECT * FROM joovili_buddies");
						  

			while ($got_users = mysql_fetch_array($users)){


		 		$fid = mysql_query("SELECT * FROM joovili_users 
					WHERE username = '".$got_users['buddy_username']."' ");

  					if (mysql_num_rows($fid) == 0) {} else {

					$fid1 = mysql_fetch_array($fid); }


  			$fid2 = mysql_query("SELECT * FROM joovili_users 
			WHERE username = '".$got_users['buddy_buddy']."' ");

  			if (mysql_num_rows($fid2) == 0) {} else {

		$fid3 = mysql_fetch_array($fid2); }




mysql_query("INSERT INTO userlist (`userid`, `relationid`, `friend`) 

VALUES 

('".$fid1['id']."', '".$fid3['id']."', 'yes')");

}







?>

[ukscotth]

solved. It was due to having one of the fields set as a primary index.

 

oops.

[marklarah]

Use the "Topic Solved" button.