I am looking for a solution (with a MySQL database and PHP) to publish lists of titles from a table in alphabetic order. But I want to go one step further than simple ORDER BY title.
I also need to have everything starting with an "A" to be on one page and everything starting with an "B" on a second page, and everything starting with an "C" on a third page ... etc. And of course within these pages everything also has to be alphabetically ordered.
How do I do this ? Does anyone know or have a good reference where I can find more information about this.