Page 1 of 1

MOD: Sorting Glossary Entries Alphabetically

Posted: Mon Oct 21, 2013 5:55 am
by Ic3MaN
Hi All, this is my first post but I have been playing around with phpMyFAQ for the last few weeks and am really impressed with, keep the great work up Thorsten and team. ^_^

In this post I'm just sharing a quick tip on how to make sure glossary entries are sorted alphabetically.

Just a word of warning, I am not a programmer so modify at your own peril.. :-p
  • 1. Open phpMyFAQ\inc\PMF\Glossary.php
  • 2. Change the SQL query starting on line 78:
    • - From this: "SELECT id, item, definition FROM %sfaqglossary WHERE lang = '%s'"
    • - To this: "SELECT id, item, definition FROM %sfaqglossary WHERE lang = '%s' ORDER BY item"
  • 3. Save the file and you're done.
This should now list the glossary in alphabetical order in both the frontend (https://{hostname}/index.php?action=glossary) and under the glossary admin page (https://{hostname}/admin/?action=glossary).