Month events

[Paulo Monteiro]

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??