[RESOLVED] Query to return records in a Month

[oh_maestro]

I am a teacher at a school that is adding morning announcements to a SQL database. I want to provide links to old announcements, organized by month.

For instance, under the heading September is list of all the days we have announcements for that month. The heading October has all the they days we have announcements for that month, etc.

The field I want to query is called NewsDate and is the Date datatype.

[dagon]

sounds like all you need to do is "ORDER BY NewsDate" in your querry

[oh_maestro]

No, I need to return all results from a month at a time. I want to return a query for whatever month is specified, such as September.

[dagon]

.. WHERE month(NewsDate) =$selected_month

MONTH(date)

[oh_maestro]

Exactly what I needed, thanks!