mysql模糊查询放数组_需要协助MySQL查询到数组并输出到回声中

我需要一些PHP编码帮助来构建一个回显来显示数据库查询的结果...(列出已登录用户的朋友？)我已经构建了大部分内容，但我不知道如何回显结果数据并将其链接到他/她的个人资料？任何帮助将不胜感激...也许是如何写出来的代码片段？

这是我的代码：

$query = mysqli_query($db_conx, $sql);

$numrows = mysqli_num_rows($query);

if ($numrows > 0){

while($row = mysqli_fetch_array($query, MYSQLI_ASSOC)){

array_push($my_friends, $row["user2"]);

array_push($my_friends, $row["user1"]);

}

//remove your id from array

$my_friends = array_diff($my_friends, array($u));

//reset the key values

$my_friends = array_values($my_friends);

mysqli_free_result($query);

} else {

echo "You have no friends.";

}

// Build My friends From Results

****this is where I need help with*****

if (array_key_exists('0', $my_friends)){

$sql = "SELECT user1, user2

FROM friends

WHERE (user1='$u' OR user2='$u')

AND accepted='1'";

$result = mysqli_query($db_conx, $sql);

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {

$my_friends = "". $row['avatar']. '&nbsp'. $row['firstname']. '&nbsp' .$row['lastname'] .""; }

}

?>

Here is my html code:

echo "

$my_friends";

?>