From 9007bb6790c283a29b28a24e4ea337a02326afc4 Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Fri, 26 Dec 2014 18:39:16 +0100 Subject: sort news by date --- includes/pages/user_news.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'includes/pages/user_news.php') diff --git a/includes/pages/user_news.php b/includes/pages/user_news.php index 8a4c0aa8..9536c2ea 100644 --- a/includes/pages/user_news.php +++ b/includes/pages/user_news.php @@ -132,7 +132,7 @@ function user_news() { else $page = 0; - $news = sql_select("SELECT * FROM `News` ORDER BY `ID` DESC LIMIT " . sql_escape($page * $DISPLAY_NEWS) . ", " . sql_escape($DISPLAY_NEWS)); + $news = sql_select("SELECT * FROM `News` ORDER BY `Datum` DESC LIMIT " . sql_escape($page * $DISPLAY_NEWS) . ", " . sql_escape($DISPLAY_NEWS)); foreach ($news as $entry) $html .= display_news($entry); -- cgit v1.2.3-54-g00ecf