get_all_labels: order by caption

[tt-rss.git] / classes / labels.php

diff --git a/classes/labels.php b/classes/labels.php
index e19a2967e3d51eb0471b655df8a06a21ad72e655..c46f70c946da6087605123040c7733114541e6d6 100644 (file)
--- a/classes/labels.php
+++ b/classes/labels.php
@@ -36,7 +36,7 @@ class Labels
        static function get_all_labels($owner_uid)      {
                $rv = array();
 
-               $result = db_query("SELECT id, fg_color, bg_color, caption FROM ttrss_labels2 WHERE owner_uid = " . $owner_uid);
+               $result = db_query("SELECT id, fg_color, bg_color, caption FROM ttrss_labels2 WHERE owner_uid = '$owner_uid' ORDER BY caption");
 
                while ($line = db_fetch_assoc($result)) {
                        array_push($rv, $line);