<?php
 
include_once("./lib/common.inc.php");
/*
 
 
agencies that use alot of consultacies
suppliers that provide alot
how much is spent overall per year
*/
 
include_header("Consultancies");
$query = "SELECT value, procurementMethod
FROM `contractnotice`
GROUP BY procurementMethod ";
 
$result = mysql_query($query);
 
echo "<table>";
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
setlocale(LC_MONETARY, 'en_US');
$value = number_format(doubleval($row[0]),2);
    echo ("<tr><td><b>{$row[1]}</b></td><td>\$$value</td></tr>");
}
echo "</table>";
mysql_free_result($result);
include_footer();
?>