Leaderboard

Yes it was that simple. To keep your function cleaner I'd add the id value as an argument of the function as well function ($id, &$mail, &$rank)

Return the vars as arguments of the function with the & on each. "function xyz(&$a, &$b)" Call the function with "function ($a, $b)" and then use $a & $b in your following code. And - how does using an array of your two values cause duplication of code? Anyway - your question is either how do I return the values or how do I echo the values? Which do you want to do?

I'd do it this way $res = $db->query("SELECT status_to , COUNT(*) as tot FROM crm_log GROUP BY status_to "); $totals = array_column($res->fetchAll(), 'tot', 'status_to'); $heads = "<tr><th>" . join('</th><th>', array_keys($totals)) . "</th></tr>\n"; $vals = "<tr><td>" . join('</td><td>', $totals) . "</td></tr>\n"; ?> <table border='1'> <?=$heads?> <?=$vals?> </table>

doing it like that means that $params is required. The way I did it means that $params can be there or not