diff options
author | Andrew Dolgov <[email protected]> | 2008-02-05 08:42:00 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-02-05 08:42:00 +0100 |
commit | 3f7e6cd005dc44e7f64ef02f9b462f0fecba11e7 (patch) | |
tree | 157f6b5a42c29e2ddb785c6e1886ab9a1663714f /modules/pref-feed-browser.php | |
parent | 2b6ed06b23041812d0319e5146426c06cbb50459 (diff) |
feed browser: prefer updated feeds when possible
Diffstat (limited to 'modules/pref-feed-browser.php')
-rw-r--r-- | modules/pref-feed-browser.php | 8 |
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); |