aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/routes/index.js5
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(
97// GET /subs 97// GET /subs
98router.get("/subs", authenticateToken, async (req, res) => { 98router.get("/subs", authenticateToken, async (req, res) => {
99 const subs = db 99 const subs = db
100 .query("SELECT * FROM subscriptions WHERE user_id = $id") 100 .query(
101 "SELECT * FROM subscriptions WHERE user_id = $id ORDER by LOWER(subreddit)",
102 )
101 .all({ id: req.user.id }); 103 .all({ id: req.user.id });
104
102 res.render("subs", { subs, user: req.user }); 105 res.render("subs", { subs, user: req.user });
103}); 106});
104 107