Add google webmaster tools and fix site map
[contractdashboard.git] / displayAgency.php
blob:a/displayAgency.php -> blob:b/displayAgency.php
--- a/displayAgency.php
+++ b/displayAgency.php
@@ -3,11 +3,12 @@
 include_once ("./lib/common.inc.php");

 if ($_REQUEST['agency']) {

 

-    include_header("Agency");

     $agency = htmlentities(strip_tags($_REQUEST['agency']));

-    //MethodCountGraph($agency);

-   // CnCGraph($agency);

-    //MethodValueGraph($agency);

+    include_header($agency);

+echo '<center><h1>'.$agency.'</h1></center>';

+//    MethodCountGraph($agency);

+ //   CnCGraph($agency);

+ //   MethodValueGraph($agency);

     /* biggest contracts

       spending by year

       spending by industry/category

@@ -28,7 +29,7 @@
     $query = 'SELECT "CNID", "description", "value", "agencyName", "category",

     "contractStart", "supplierName"

     FROM contractnotice

-    WHERE "agencyName" = :agency

+    WHERE "agencyName" like :agency

     ORDER BY "value" DESC limit 100';

     $query = $conn->prepare($query);

     $query->bindParam(":agency", $agency);