--- a/displayConsultancies.php +++ b/displayConsultancies.php @@ -1,4 +1,31 @@ +<?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(); +?> + + +