diff options
| -rw-r--r-- | modules/aggregator.module | 2 | ||||
| -rw-r--r-- | modules/aggregator/aggregator.module | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/aggregator.module b/modules/aggregator.module index dd371af95..e86244844 100644 --- a/modules/aggregator.module +++ b/modules/aggregator.module @@ -1021,7 +1021,7 @@ function aggregator_page_list_submit($form_id, $form) { * Menu callback; displays all the feeds used by the aggregator. */ function aggregator_page_sources() { - $result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image'); + $result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image ORDER BY last DESC, f.title'); $output = "<div id=\"aggregator\">\n"; while ($feed = db_fetch_object($result)) { $output .= '<h2>'. check_plain($feed->title) ."</h2>\n"; diff --git a/modules/aggregator/aggregator.module b/modules/aggregator/aggregator.module index dd371af95..e86244844 100644 --- a/modules/aggregator/aggregator.module +++ b/modules/aggregator/aggregator.module @@ -1021,7 +1021,7 @@ function aggregator_page_list_submit($form_id, $form) { * Menu callback; displays all the feeds used by the aggregator. */ function aggregator_page_sources() { - $result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image'); + $result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image ORDER BY last DESC, f.title'); $output = "<div id=\"aggregator\">\n"; while ($feed = db_fetch_object($result)) { $output .= '<h2>'. check_plain($feed->title) ."</h2>\n"; |