Re: [PHP] Getting Results for a month from a date field

|MONTH(date)| Returns the month for |date|, in the range |1| to |12|: SELECT * FROM employees WHERE MONTH(hiredate)='$month' Hunter, Jess wrote: I have a field named "hiredate" and it is in the typical MySQL format (-MM-DD) what I am trying to do it be able to create a query that when I

[PHP] Getting Results for a month from a date field

I have a field named "hiredate" and it is in the typical MySQL format (-MM-DD) what I am trying to do it be able to create a query that when I put in a particular month it will give me the results regardless of the year the person was hired. This is so I can generate a "anniversary" report to