--- a/displayCategory.php
+++ b/displayCategory.php
@@ -5,11 +5,20 @@
echo "
".$_REQUEST['category']."
";
$query = "SELECT CNID, description, value, agencyName, category, contractStart, supplierName
FROM `contractnotice`
- WHERE childCN = 0
+ WHERE childCN is null
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);
@@ -30,10 +39,15 @@
include_header("Categories");
$query = "SELECT sum(value), category
FROM `contractnotice`
-WHERE childCN = 0
+WHERE childCN is null
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);