--- a/index.php
+++ b/index.php
@@ -1,11 +1,36 @@
 <?php
 include_once ("./lib/common.inc.php");
 include_header("Home");
-echo '        <div class="hero-unit">
-          <h1>Hello, world!</h1>
-          <p>Vestibulum id ligula porta felis euismod semper. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit.</p>
-          <p><a class="btn primary large">Learn more &raquo;</a></p>
-        </div>';
+?>
+        <div class="hero-unit">
+          <h1>Contract Dashboard</h1>
+        </div>
+<table>
+<?php
+$query = 'SELECT DATE("importDate") d FROM contractnotice ORDER BY "importDate" DESC limit 1';
+$query = $conn->prepare($query);
+$query->execute();
+databaseError($conn->errorInfo());
+$date = $query->fetch();
+$query = 'SELECT * FROM contractnotice where DATE("importDate") = ? 
+OFFSET random()*(select count(*) from contractnotice where DATE("importDate") = ?) LIMIT 10';
+$query = $conn->prepare($query);
+$query->execute(Array($date[0],$date[0]));
+databaseError($conn->errorInfo());
+$res = $query->fetchAll(PDO::FETCH_ASSOC);
+
+foreach ($res as $row) {
+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>";
 include_footer();
 ?>