Arranging serial number in descending order

1 files changed, 3 insertions, 2 deletions

diff --git a/lab_details.inc b/lab_details.inc
index 6d05ccd..a81efdb 100755
--- a/lab_details.inc
+++ b/lab_details.inc
@@ -6,6 +6,7 @@ function lab_migration_completed_labs_all()
     $query = db_select('lab_migration_proposal');
     $query->fields('lab_migration_proposal');
     $query->condition('approval_status', 3);
+    $query->orderBy('approval_date', DESC);
     $result = $query->execute();
     //$result = db_query($query);
     if ($result->rowCount() == 0)
@@ -15,7 +16,7 @@ function lab_migration_completed_labs_all()
     else
       {
         $preference_rows = array();
-        $i = 1;
+        $i = $result->rowCount();
         while ($row = $result->fetchObject())
           {
             $approval_date = date("Y", $row->approval_date);
@@ -25,7 +26,7 @@ function lab_migration_completed_labs_all()
                 l($row->lab_title, "lab-migration/lab-migration-run/" . $row->id),
                 $approval_date
             );
-            $i++;
+            $i--;
           }
         $preference_header = array(
             'No',