feed browser: prefer updated feeds when possible

1 files changed, 6 insertions, 2 deletions

diff --git a/modules/pref-feed-browser.php b/modules/pref-feed-browser.php
index 6e4abce36..034d51202 100644
--- a/modules/pref-feed-browser.php
+++ b/modules/pref-feed-browser.php
@@ -121,9 +121,13 @@
 		while ($line = db_fetch_assoc($result)) {
 			$feed_url = $line["feed_url"];
 			$subscribers = $line["subscribers"];
-		
+
+			// mysql returns NULL records first by default
+			if (DB_TYPE == "mysql") $order_fix = "DESC";
+
 			$det_result = db_query($link, "SELECT site_url,title,id 
-				FROM ttrss_feeds WHERE feed_url = '$feed_url' LIMIT 1");
+				FROM ttrss_feeds WHERE feed_url = '$feed_url' 
+				ORDER BY last_updated $order_fix LIMIT 1");
 
 			$details = db_fetch_assoc($det_result);