--- a/displayAgency.php
+++ b/displayAgency.php
@@ -23,6 +23,37 @@
   Breakdown percentage,number,value by procurement type
   Histograph, overlaying number value reported per week over X years
   Compliance statistics: amendments, delay in reporting average and number completely late*/
+  
+    $query = "SELECT CNID, description, value, agencyName, category, contractStart, supplierName
+    FROM `contractnotice`
+    WHERE agencyName = '".mysql_real_escape_string($agency)."'
+    ORDER BY value DESC";
+    echo $query;
+  $result = mysql_query($query);
+
+  echo "<table>  <thead>
+    <tr>
+      <th>Contract Notice Number</th>
+      <th>Contract Description</th>
+      <th>Total Contract Value</th>
+      <th>Agency</th>
+      <th>Contract Start Date</th>
+      <th>Supplier</th>
+    </tr>
+  </thead>";
+  while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
+    setlocale(LC_MONETARY, 'en_US');
+    $value = number_format(doubleval($row['value']) , 2);
+    echo ("<tr>
+    <td><a href=\"displayContract.php?CNID={$row['CNID']}\">{$row['CNID']}</a></td>
+    <td><b>{$row['description']}</b></a></td>
+    <td>\$$value</td><td>{$row['agencyName']}</td>
+    <td>{$row['contractStart']}</td>
+    <td>{$row['supplierName']}</td>
+    </tr>");
+  }
+  echo "</table>";
+  mysql_free_result($result);
 } else {
     /*
      split by portfolio
@@ -33,7 +64,12 @@
 WHERE childCN = 0
 GROUP BY agencyName ";
   $result = mysql_query($query);
-  echo "<table>";
+  echo "<table>  <thead>
+    <tr>
+      <th>Agency</th>
+      <th>Total Contracts Value</th>
+    </tr>
+  </thead>";
   while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
     setlocale(LC_MONETARY, 'en_US');
     $value = number_format(doubleval($row[0]) , 2);