From 4999fa77ef0156f791d29e294585fcd920212f79 Mon Sep 17 00:00:00 2001
From: horus
Date: Wed, 8 Apr 2020 07:10:03 +0200
Subject: Cleaning up the topics page.

---
 app/Http/Controllers/IndexController.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'app/Http/Controllers/IndexController.php')

diff --git a/app/Http/Controllers/IndexController.php b/app/Http/Controllers/IndexController.php
index dbbbfb1..955a8d8 100644
--- a/app/Http/Controllers/IndexController.php
+++ b/app/Http/Controllers/IndexController.php
@@ -89,8 +89,9 @@ class IndexController extends Controller
 
     function topicindex() {
 	    $categories = Category::orderBy('name');
+	    $letters = DB::select("SELECT DISTINCT LEFT(name, 1) as name FROM category ORDER BY left(name, 1);");
 
-	    return view('topicindex', ['topics' => $categories]);
+	    return view('topicindex', ['topics' => $categories, 'letters' => $letters]);
     }
 
     public function random() {
-- 
cgit v1.2.3