I have registers in a mysql DB and I want to show them for months. I think I have a var like this:

PHP Code:
$id "month(now())";
                
$sql "select * from agenda_geral where agenda='desporto' and month = ".$id." and area_ID = 1 order by day" 
But what I have to do for show the next or the previous month events in the same page without create a new??