MySQLPHP不会获取所有行-MySQLPHPwon'tfetchallrows

While trying to make an overview of added "friends", the following code only returns the last added friend.

在尝试概述添加的“朋友”时,以下代码仅返回最后添加的朋友。

mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name WHERE bruger1='$usrname' AND status='Godkendt'";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
  $venner=$rows['bruger2'];
}
$tbl_name="brugere";
$sql="SELECT * FROM $tbl_name WHERE email LIKE '$venner%'";
$result=mysql_query($sql);
?>

  


  
    
    
Navn: 
    
Mail: 
    
Hjem: 
    
FacebookID: