SELECT
A.activity_id
, A.activity_name
, A.activity_title
, AD.activity_date
, DATE_FORMAT( activity_date, '%d/%m') AS newDate
FROM
activities A
INNER
JOIN activity_dates AD
ON AL.activity_id = AD.activity_id
ORDER
BY activity_name, MONTH(activity_date), DAY(activity_date)
With this I try to ORDER BY MONTH first and after that by DAY, but it keeps ordering by DAY
Hi Guido, It is indeed. When I test it with just 1 activity_id it gives the right order, as soon as I come to this page where all activities are listed then the wrong ordering takes place.