--- a/displayConfidentialities.php +++ b/displayConfidentialities.php @@ -1,4 +1,31 @@ -agencies that use alot of consultacies +<?php + +include_once("./lib/common.inc.php"); +/* + + +agencies that use alot of Confidentialities suppliers that provide alot how much is spent overall per year +*/ +include_header("Confidentialities"); +$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(); +?> + + +