diff options
author | Andrew Dolgov <[email protected]> | 2005-11-25 14:30:34 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-11-25 14:30:34 +0100 |
commit | 18d37445a33ea01d099ef4d09840f0351f593ee8 (patch) | |
tree | efd4a9f710d1232d09c490029dab9aed48553a6c | |
parent | e98a3f6525a570913d1f957c12773cd1f1047aca (diff) |
fix OPML export for uncategorized feeds
-rw-r--r-- | opml.php | 8 |
1 files changed, 3 insertions, 5 deletions
@@ -35,11 +35,9 @@ $result = db_query($link, "SELECT ttrss_feeds.feed_url AS feed_url, ttrss_feeds.title AS title, - ttrss_feed_categories.title AS cat_title - FROM ttrss_feeds,ttrss_feed_categories - WHERE - cat_id = ttrss_feed_categories.id - ORDER BY ttrss_feed_categories.title,ttrss_feeds.title"); + (SELECT title FROM ttrss_feed_categories WHERE id = cat_id) as cat_title + FROM ttrss_feeds + ORDER BY cat_title,title"); } else { $result = db_query($link, "SELECT * FROM ttrss_feeds ORDER BY title"); |