order subs in asc alphabetic order

1 files changed, 4 insertions, 1 deletions

diff --git a/src/routes/index.js b/src/routes/index.js
index f4c0fc9..ef395ed 100644
--- a/src/routes/index.js
+++ b/src/routes/index.js
@@ -97,8 +97,11 @@ router.get(
 // GET /subs
 router.get("/subs", authenticateToken, async (req, res) => {
         const subs = db
-                .query("SELECT * FROM subscriptions WHERE user_id = $id")
+                .query(
+                        "SELECT * FROM subscriptions WHERE user_id = $id ORDER by LOWER(subreddit)",
+                )
                 .all({ id: req.user.id });
+
         res.render("subs", { subs, user: req.user });
 });