This topic is locked

Month name only in German and unsorted

9/26/2023 11:40:00 AM
PHPRunner General questions
Karlo_from_Germany author

In one application, I generated both the year and the month from a date using a MySQL query. Works perfect.
The filter for the month displayed on the page works correctly, but only in English and unsorted.
How can I achieve that:

  • The months are displayed in German


  • The months from January to December are displayed in correct order?



Thanks in advancee
img alt

M
Mark Kramer 9/26/2023

Create another column in your table that "month number" that corresponds with the month i.e.

Jan = 1,
Feb = 2,

March= 3.
etc.
Then sort by the month number.