Searching and Count within array

Hi Master, I have an array as : $myArray = array('four','four','four','four','one,,'three','three','three','two','two'); Then I want output like this, //====== four is 4 times three is 3 times two is 2 times one is 1 times //(it 's better if one is 1 time). //======= How can I search and count the array? Or better search and count directly using MySQL API? Note : array was generated from MySQL DB //========== <?php $connection = mysql_connect("localhost","user","pass"); mysql_select_db("ecd"); $result = mysql_query("SELECT * FROM pre_main ORDER BY mDate DESC LIMIT 20",$connection); while ($row = mysql_fetch_row($result)) { $myArray[] = $row[0]; } sort ($myArray);//sorting array //result : $myArray = array('two','two','three','three','three','four','four','four','four','one'); ?> //========= Thanks in advance