PHP how to output the top array_count_values value from array?

Question

I have a table that I need to find "top trusted builder" from, Trusts are separated by " ; ", So I need to pull all the data, explode the usernames, order and count them, and Im stuck on finally outputting the top username form the array, I have posted up the full segment of PHP, because im sure there has to be a much better way of doing this.

<?php 
$GTB = $DBH->query('SELECT builders from griefprevention_claimdata where builders <> ""');
$GMCB->setFetchMode(PDO::FETCH_ASSOC);

$buildersarray = array();

while($row = $GTB->fetch()) {

      $allbuilders = explode(";", $row['builders']);
        for($i = 0; $i < count($allbuilders); $i++)
          {
            $buildersarray[] = $allbuilders[$i];
          }
}

echo "<pre>";
print_r(array_count_values(array_filter($buildersarray)));
echo "</pre>";
?>

Outputs

Array
(
[username1] => 4
[username2] => 1
[username3] => 1
)

Answer 1

You can return the array from the array_count_values command into a new array called $topbuilders, and then echo out the current (first) record:

$topbuilders = array_count_values(array_filter($buildersarray));
echo current(array_keys($topbuilders)).', Rank = '.current($topbuilders);

current() will return the first item in an associative array.

Answer 2

Instead of using array_count_values() it would be better to use the names as the key to a frequency array:

$GTB = $DBH->query('SELECT builders from griefprevention_claimdata where builders <> ""');

$result = array();

while (($builders = $GTB->fetchColumn()) !== false) {
    foreach (explode(";", $builders) as $builder) {
        if (isset($result[$builder])) {
            $result[$builder]++;
        } else {
            $result[$builder] = 1;
        }
}
// sort descending based on numeric comparison
arsort($result, SORT_NUMERIC);

echo "Name = ", key($result), " Count = ", current($result), "\n";