From 589c21ef7c1fef178eb7e8047d71f91df61fbe93 Mon Sep 17 00:00:00 2001 From: Marvin Borner Date: Thu, 1 Oct 2020 17:56:03 +0200 Subject: Quotes are basically functional --- quotes/index.js | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'quotes/index.js') diff --git a/quotes/index.js b/quotes/index.js index 66aeb5e..31ea2a5 100644 --- a/quotes/index.js +++ b/quotes/index.js @@ -21,7 +21,7 @@ app.post("/api/add", async (req, res) => { app.get("/api/list", async (req, res) => { const quotes = await db.query( - "SELECT quotes.id, name, middlename, surname, quote FROM quotes INNER JOIN users AS a ON author_id = a.id" + "SELECT quotes.id, name, middlename, surname, quote FROM quotes INNER JOIN users AS a ON author_id = a.id ORDER BY name" ); res.json(quotes); }); -- cgit v1.2.3