$array = array(); $dbquery = $DB_site->query("SELECT field5 FROM " . TABLE_PREFIX . "userfield"); while ($queryrow = $DB_site->fetch_array($dbquery)) { $array[$queryrow['field5']]++; } reset($array); while (list($key, $val) = each($array)) { $f5stat .= $val . " = " . $key; }