Data update
[contractdashboard.git] / displayCategory.php
blob:a/displayCategory.php -> blob:b/displayCategory.php
--- a/displayCategory.php
+++ b/displayCategory.php
@@ -5,7 +5,7 @@
     echo "<center><h1>".$_REQUEST['category']."</h1></center>";
   $query = 'SELECT "CNID", description, value, "agencyName", category, "contractStart", "supplierName"
     FROM contractnotice
-    WHERE "childCN" is null 
+    WHERE '.$yearQ.' "childCN" is null 
     AND category = :category
     ORDER BY value DESC';
 $query = $conn->prepare($query);
@@ -42,7 +42,7 @@
     include_header("Categories");
 $query = 'SELECT sum(value), category
 FROM contractnotice
-WHERE "childCN" is null
+WHERE '.$yearQ.' "childCN" is null
 GROUP BY category ORDER BY sum(value) DESC ';
 $query = $conn->prepare($query);
 	$query->execute();
@@ -62,3 +62,4 @@
 }
 include_footer();
 ?>
+