From 3fcd6b69c8e9d0acd5b679fd609db82da20ffb3e Mon Sep 17 00:00:00 2001
From: Michael McVady <femtonaut@gmail.com>
Date: Sun, 6 Mar 2022 19:54:10 -0500
Subject: Sort results by date

---
 src/clog.c | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src')

diff --git a/src/clog.c b/src/clog.c
index 4c5f0c2..d3fa324 100644
--- a/src/clog.c
+++ b/src/clog.c
@@ -68,7 +68,7 @@ page(struct http_request *req)
 	err = kore_pgsql_query(
 		&sql,
 		"SELECT id, title, created_at::DATE, body FROM posts "
-		"ORDER BY id ASC;"
+		"ORDER BY updated_at DESC;"
 	);
 	if (!err) {
 		kore_pgsql_logerror(&sql);
-- 
cgit v1.2.3