> SELECT DISTINCT MONTHNAME(date) AS month FROM date WHERE (date <> > '0000-00- 00') ORDER BY month ASC > > At the moment that returns the months in alphabetical order... how > can I return them in the correct calender order? > speaking as a person who is not a mysql expert... what happens when you order by MONTHNAME(date) ? HTH