เรียงค่า max ถ้าซ้ำกัน ก็ไม่เอา ช่วยหน่อยน่ะค่ะ T-T

$memberid_value2=$_SESSION["memberid"];	
	
	$numssort = 0;
		$sqlsort="SELECT * FROM table_message where memberid=".$_SESSION["memberid"]." or friendid = ".$_SESSION["memberid"]." order by message_id ASC";	
	
	//echo "SQL2 = ".$sqls2."<br>";
				$resultssort=$db->query($sqlsort);	
				$numssort=$resultssort->size(); 
				if($numssort>0){
	   				for($i=0;$i<$numssort;$i++){				
						$rowssort =$resultssort->next(); 
						$message_sort=$rowssort['message_id'];
						$friendid_sort=$rowssort['friendid'];	

                                                                                     }
                                                               }
$array[$i] = $friendid_sort;
$arraym[$i] = $message_sort;

for($i=0;$i<$numssort;$i++){
 for($j=0;$j<$i;$j++){
	if ($array[$j]<$array[$j+1]){
		$temp = $array[$j+1];
		$array[$j+1] = $array[$j];
		$array[$j] = $temp ;
		
		$tempm = $arraym[$j+1];
		$arraym[$j+1] = $arraym[$j];
		$arraym[$j] = $tempm ;

	}
   }
}

for($i=0;$i<=$numssort;$i++){
   echo "numx ". $i . " = ". $array[$i] . " / message = ". $arraym[$i] ."<br>";
}

SELECT `memberid`,MAX(`messageid`) as MAX FROM `test`GROUP BY `memberid` ORDER BY MAX DESC