[SOLVED] Display birthdays in order of day

[stevesimo]

Hi, I have a PHP script used on an intranet which displays a list of employees whose birthday occurs during the current month.  i.e. all birthdays in the month of July.  NOTE: I only want to show the day, not the full date of birth.  The date of birth field is currently stored as a date yyyy-mm-dd.  My problem is this: I want to display the list of birthdays in order of day order and not date order.  Therefore simply saying order by dob will order the list in order of age.

 

Does anyone know how to achieve this?

 

Just to clarify what I am trying to achieve, the sample output would be something like:

 

There are 3 birthdays in July

 

4th  Employee 1

13th Employee 2

21st Employee 3

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_dayofmonth

[JonnoTheDev]

example sql (im guessing your tables)

SELECT name, dob FROM employees WHERE MONTH(dob) = MONTH(CURDATE()) ORDER BY DAYOFMONTH(dob) ASC