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