| <?php | |
| include_once("./lib/common.inc.php"); | |
| /* | |
| agencies that use alot of consultacies | agencies that use alot of consultacies |
| suppliers that provide alot | suppliers that provide alot |
| how much is spent overall per year | 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(); | |
| ?> | |