$connect = mysql_connect("localhost", "root", "") or die (mysql_error());
$connect;
mysql_select_db ("phplogin");
$userfriend = mysql_query ("SELECT req FROM friends WHERE user='$profileid' AND confirmed=1");
$userfriendarray = mysql_fetch_array($userfriend);
$userfriendreq = $userfriendarray['req'];
 
 
$userreq = mysql_query ("SELECT user FROM friends WHERE req='$profileid' AND confirmed=1");
if ($userreq != 0)
{
$userreqarray = mysql_fetch_array($userreq);
$userreq2 = $userreqarray['user'];
}
if ($userreqarray != 0 && $userfriendarray!= 0) // merges arrays if they both contain data
{
$friends = array_merge($userreqarray, $userfriendarray);
$friend1 = array_rand($friends);
}
elseif ($userreqarray != 0)
{
var_dump ($userreqarray);
foreach($userreqarray as $userreq2);
	{
	echo "$userreq2";
	}
}
elseif($userfriendarray != 0)
{
foreach($userfriendarray as $req5 => $reqno) // there is one entry in the table yet this returns 2 values? i dont know why?
	{
	 echo "$reqno";
	}
}
echo '<br></center></a></div>';
 
 
 
?>

$rs = mysql_query("SELECT * FROM friends WHERE (reg = '$id' AND confirmed = '1') OR (user ='$id' AND confirmed = '1')");
 
while($data = mysql_fetch_array($rs)){
   if($data['user'] != $id){
      $friendarray[] = $data['user'];
   }else{
      $friendarray[] = $data['req'];
   }
}

$rs = mysql_query("SELECT friends.*,users2.username,reqs.username AS requsername
from friends
LEFT JOIN users users2 ON friends.user = users2.id
LEFT JOIN users reqs ON friends.req = reqs.id WHERE confirmed = 1 AND (req = 1 OR `user` = 1)");

while($data = mysql_fetch_array($rs)){
   if($data['user'] != $id){
      $friendarray[] = $data['username'];
 
   }else{
      $friendarray[] = $data['requsername'];
   }
}

while($data = mysql_fetch_array($rs)){
   if($data['user'] != $id){
      $friendarray[] = array($data['user'],$data['username']);
 
   }else{
      $friendarray[] = array($data['req'], $data['requsername']);
   }
}

$rs = mysql_query("SELECT friends.*,users2.username,reqs.username AS requsername
from friends
LEFT JOIN users users2 ON friends.user = users2.id
LEFT JOIN users reqs ON friends.req = reqs.id WHERE confirmed = 1 AND (req = 1 OR `user` = 1)");

id    username
1     ardav
2     filo34
3     canzo
4     peeps456
5     costas
6     triage
7     carchaser
8     rugbyboy20

id    user     req     confirmed
1     1          8        1
2     1          6        1
3     2          1        1
4     3          1        0
5     2          3        1
6     4          8        1

id    user    req    confirmed   username   requsername
1     1         8       1          ardav          rugbyboy20 
2     1         6       1          ardav          triage
3     2         1       1          filo34          ardav

array(
  array(8, 'rugbyboy20'),
  array(6, 'triage'),
  array(2, 'filo34')
)

echo "<a href=\"profile.php?id={$fieldarray[$i][0]}\">{$fieldarray[$i][1]}</a>";