Database Help

I have a database with news grouped by month and I was wondering how to show only the current month's news to show.

Info:
Table: News
Row with Month names: Month
Row with Years: Year

Hey calebrw:
Try this:

<!--create a variable to hold the current month -->
<cfset cMonth = #Month(Now())#>

<--!Create a query to retrieve news from the database-->
<cfquery name="anyName" datasource="yourDBName">
SELECT news id, title, body , month (whatever you want to display)
FROM news
WHERE month = '#cMonth#'
ORDER BY yourChoice
</cfquery>

NOTE: The query will only retrieve news that meet the criteria determined by the "WHERE" statement. In this case, the current month.