--- a/displayCategory.php
+++ b/displayCategory.php
@@ -9,7 +9,16 @@
AND category = '" . $_REQUEST['category'] . "'
ORDER BY value DESC";
$result = mysql_query($query);
- echo "
";
+ echo "
+
+ Contract Notice Number |
+ Contract Description |
+ Total Contract Value |
+ Agency |
+ Contract Start Date |
+ Supplier |
+
+ ";
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
setlocale(LC_MONETARY, 'en_US');
$value = number_format(doubleval($row['value']) , 2);
@@ -33,7 +42,12 @@
WHERE childCN = 0
GROUP BY category ORDER BY sum(value) DESC ";
$result = mysql_query($query);
-echo "";
+ echo "
+
+ Category |
+ Total Contracts Value |
+
+ ";
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
setlocale(LC_MONETARY, 'en_US');
$value = number_format(doubleval($row[0]) , 2);