From 3b0948c4abdef0d54779de5e1e25d0c070d4c7bf Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 18 Nov 2005 13:59:26 +0100 Subject: sort tags in feedlist output, "technorati tag:" is stripped from tagname --- backend.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'backend.php') diff --git a/backend.php b/backend.php index 91853d4b8..2f1e7c2f8 100644 --- a/backend.php +++ b/backend.php @@ -258,9 +258,10 @@ $result = db_query($link, "SELECT tag_name,count(ttrss_entries.id) AS count FROM ttrss_tags,ttrss_entries WHERE post_id = ttrss_entries.id AND unread = true - AND ttrss_tags.owner_uid = '$owner_uid' GROUP BY tag_name + AND ttrss_tags.owner_uid = '$owner_uid' GROUP BY tag_name UNION - select tag_name,0 as count FROM ttrss_tags WHERE owner_uid = '$owner_uid'"); + select tag_name,0 as count FROM ttrss_tags WHERE owner_uid = '$owner_uid' + ORDER BY tag_name"); $tags = array(); -- cgit v1.2.3-54-g00ecf