query("SELECT distinct(b.from) FROM msgs b where b.`to` = 'admin' or b.`from` = 'admin' GROUP BY b.from order by b.idz desc"); while($row = $query1->fetch(PDO::FETCH_ASSOC)) { $query2 = $db->query("SELECT `idz` from msgs where `from` = '$row[from]' and `to` = 'admin' order by `idz` DESC LIMIT 1"); $row3 = $query2->fetch(PDO::FETCH_ASSOC); $ids[] = $row3['idz']; }; arsort($ids); foreach ($ids as &$value) { $query3 = $db->query("SELECT `from` from `msgs` where `idz` = $value"); $row3 = $query3->fetch(PDO::FETCH_ASSOC); echo $row3['from']; echo "
"; }