Re: Month events

[Bill Karwin]

Try something like this:

select *
from agenda_geral
where agenda='desporto' and area_ID = 1
and (month = month(now()) or month = month(now() - interval 1 month))
order by day

By the way, is your query meant to show events from the current month of any year, or just the current year? It shows events from the current month of any year.

Regards,
Bill K.