[RESOLVED] Display Multiple Results

[scrypte]

Ok I am having trouble right now displaying multiple results, if you can help me with this it would be greatly appreciated.

   $sql = "SELECT * FROM friends WHERE `userid_1`='$userid' && `status`='2' ORDER BY `index` DESC LIMIT 0,50";
   $result = @mysql_query($sql) or die("couldn't execute query  $sql.".mysql_error());
   while($row = mysql_fetch_array($result)) {
   $friends1++;
   $friend1=$row{'userid_2'};
	}
   $sql = "SELECT * FROM users WHERE `userid`='$friend1'";
   $result = @mysql_query($sql) or die("couldn't execute query .".mysql_error());
   while($row = mysql_fetch_array($result)) { 
   		$username1=$row{'username'};
   		$index1=$row{'index'};
   		echo "<a href=viewprofile.php?id=$friend1>$username1</a>, \n";
}
   $sqlb = "SELECT * FROM friends WHERE `userid_2`='$userid' && `status`='2' ORDER BY `index` DESC LIMIT 0,50";
   $resultb = @mysql_query($sqlb) or die("couldn't execute query  $sqlb.".mysql_error());
   while($row = mysql_fetch_array($resultb)) {
   $friends2++;
   $friend2=$row{'userid_1'};   

	}
   $sql = "SELECT * FROM users WHERE `userid`='$friend2'";
   $result = @mysql_query($sql) or die("couldn't execute query .".mysql_error());
   while($row = mysql_fetch_array($result)) {
   		$username2=$row{'username'};
   		$index2=$row{'index'};
   		echo "<a href=viewprofile.php?id=$friend2>$username2</a>, \n";
}

[obrienkev]

What errors are you getting or what should be output?

[scrypte]

the output should read something like this

username1, username1, username1, username2, username2, username2,

but for some reason it only pulls one of each