} } $sql = "SELECT idSender, idRecipient FROM `messages` WHERE idSender='" . $userId . "' GROUP BY idRecipient"; $result = mysqli_query($link, $sql); while ($row = mysqli_fetch_assoc($result)) { $talkers[] = getUserDATA($row['idRecipient']); } $sql = "SELECT idSender, idRecipient FROM `messages` WHERE idRecipient='" . $userId . "' GROUP BY idSender"; $result = mysqli_query($link, $sql); while ($row = mysqli_fetch_assoc($result)) { foreach ($talkers as $key => $value) { if ($value['idUser'] == $row['idSender']) { break; } else { if ($key == count($talkers)) { $talkers[] = getUserDATA($row['idSender']); } } } } if (isset($_GET['id'])) { $sql = "SELECT * FROM `messages` WHERE (idSender='" . $userId . "' AND idRecipient='" . $idRecipient . "' ) OR (idSender='" . $idRecipient . "' AND idRecipient='" . $userId . "' ) order BY createDate"; $result = mysqli_query($link, $sql); while ($row = mysqli_fetch_assoc($result)) { $messages[] = $row; } foreach ($messages as $key => &$message) { if ($message['idSender'] == $userId) { $message['avatar'] = $userData['avatar']; } else { $message['avatar'] = $recipient['avatar'];
<?php include_once "config.php"; include_once "DB.php"; $user = getUserDATA($_GET['id']); $user['gender'] = getUserGENDER($user['gender']); $sql_info = "SELECT * FROM `friendsPair` WHERE `idSender` = '" . $user['idUser'] . "' \n\t\t\tOR `idRecipient` = '" . $user['idUser'] . "'"; $result = mysqli_query($link, $sql_info); $user['numFriends'] = mysqli_num_rows($result);