diff options
| author | horus | 2020-04-08 07:10:03 +0200 |
|---|---|---|
| committer | horus | 2020-04-08 07:10:03 +0200 |
| commit | 4999fa77ef0156f791d29e294585fcd920212f79 (patch) | |
| tree | 8f3dd02945b388ba6caa3316832ad0b73115b77a /app/Http/Controllers | |
| parent | d8219a9fb5454aaf0bb2e24dcc1d41dca7dae975 (diff) | |
| download | curious-4999fa77ef0156f791d29e294585fcd920212f79.tar.gz | |
Cleaning up the topics page.
Diffstat (limited to 'app/Http/Controllers')
| -rw-r--r-- | app/Http/Controllers/IndexController.php | 3 |
1 files changed, 2 insertions, 1 deletions
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() { |
