Searching and Count within array

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
 

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux