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
 

Reply via email to