Order genres alphabetically

diff --git a/backend/routes/genre/genre.go b/backend/routes/genre/genre.go
index 0304b64..a3808e0 100644 (file)
--- a/backend/routes/genre/genre.go
+++ b/backend/routes/genre/genre.go
@@ -45,7 +45,8 @@ WHERE NAME = lower(?)`,
 
                rows, err := env.Db.Db.Query(`
 SELECT ID, NAME
-FROM GENRE`,
+FROM GENRE
+ORDER BY NAME ASC`,
                )
                if err != nil {
                        http.Error(w, http.StatusText(http.StatusInternalServerError), http.StatusInternalServerError)