From 61419ce10ec920aae29537f9bc0f8295d94baddf Mon Sep 17 00:00:00 2001
From: Dylan Lloyd <dylan@dylansserver.com>
Date: Tue, 21 Feb 2012 16:45:53 -0500
Subject: [PATCH] added ORDER BY rank to projects sql

---
 index.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/index.php b/index.php
index b95b16d..8cb1d62 100644
--- a/index.php
+++ b/index.php
@@ -194,7 +194,7 @@ OTHER_PROJECTS;
 
   protected function display_exhibits() {
     echo "<div id='exhibit'>";
-    $sql = "SELECT text FROM projects";
+    $sql = "SELECT text FROM projects ORDER BY rank";
     $result = $this->db->query($sql);
     while ($entry = $result->fetch_object()) {
       echo $entry->text;
@@ -208,7 +208,7 @@ OTHER_PROJECTS;
           <h3>my projects:</h3>
         </li>
 HEREDOC;
-    $sql = "SELECT title FROM projects";
+    $sql = "SELECT title FROM projects ORDER BY rank";
     $result = $this->db->query($sql);
     while ($entry = $result->fetch_object()) {
       echo "<li><a class='tab' href='$entry->title'>$entry->title</a></li>";
-- 
2.30.2