Order array based on number of duplicates

[chemlight]

I'm trying to figure out how to order an array based on the number of duplicates, and then remove all duplicates.

This is my code right now:

foreach($acID as $searchterms){
$results = mysql_query(SELECT * FROM table
     WHERE field LIKE '%$searchterms%')
 
   while($row = mysql_fetch_array($results)){
         array_push($resultArray, $row['id']);
         }
}

My Array ends up looking like:
$resultArray[0] => 818
$resultArray[1] => 1009
$resultArray[2] => 818
$resultArray[3] => 300
$resultArray[4] => 818
$resultArray[5] => 300

What I want is a final array that will sort $resultArray so that the items with the most duplicates are listed first, and then removes duplicates. So, it should look like this:

$finalArray[0] => 818
$finalArray[1] => 300
$finalArray[2] => 1009

Any help would be greatly apreciated.

[Dormilich]

have a look at PHP's array functions (PHP: Array Functions). especially array_diff_* and array_intersect _* might be of interest.

there might be even some statement in the SQL syntax avoiding duplicate results, but you should ask for that in the MySQL forum.

[Markus]

I think DISTINCT can help you here. And also ORDER BY.