Re: Searching and Count within array

array_count_values() Bagus Nugroho wrote: > 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 > >