Alexander Nicolaysen Sørnes : note: Show app notes above version notes

[Alexander Nicolaysen Sørnes]

Module: appdb
Branch: master
Commit: b5e4093097c36f92e3404fbeee6b61fae552f3a2
URL:    http://source.winehq.org/git/appdb.git/?a=commit;h=b5e4093097c36f92e3404fbeee6b61fae552f3a2

Author: Alexander Nicolaysen Sørnes <alex at thehandofagony.com>
Date:   Wed Jul 29 17:54:18 2009 +0200

note: Show app notes above version notes

---

 include/note.php |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/include/note.php b/include/note.php
index 315d627..754e585 100644
--- a/include/note.php
+++ b/include/note.php
@@ -286,7 +286,7 @@ class Note {
         {
             $oVersion = new version($iVersionId);
             $oApp = $oVersion->objectGetParent();
-            $hResult = query_parameters("SELECT noteId FROM appNotes WHERE versionId  = '?' OR (appId = '?' AND (versionId = '?' OR versionId = '?'))", $iVersionId, $oApp->objectGetId(), APPNOTE_SHOW_FOR_ALL, APPNOTE_SHOW_FOR_VERSIONS);
+            $hResult = query_parameters("SELECT noteId FROM appNotes WHERE versionId  = '?' OR (appId = '?' AND (versionId = '?' OR versionId = '?')) ORDER BY versionId,noteId", $iVersionId, $oApp->objectGetId(), APPNOTE_SHOW_FOR_ALL, APPNOTE_SHOW_FOR_VERSIONS);
         } else if($iAppId)
         {
             $hResult = query_parameters("SELECT noteId FROM appNotes WHERE appId = '?' AND (versionId = '?' OR versionId = '?')", $iAppId, APPNOTE_SHOW_FOR_ALL, APPNOTE_SHOW_FOR_APP);