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(-)
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